True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update tablename set column1 = '' where tablename .id = (select id2id from tablename2 where tablename2.column2 = 'xyz'); Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about CollectivesStack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack InternalTrue, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update tablename set column1 = '' where tablename .id = (select id2id from tablename2 where tablename2.column2 = 'xyz'); True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update tablename set column1 = '' where tablename .id = (select id2 from tablename2 where tablename2.column2 = 'xyz'); True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update tablename set column1 = '' where tablename .id = (select id from tablename2 where tablename2.column2 = 'xyz'); True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update <table>tablename set column1 = '' where <table>tablename .id = (select id2 from <table2>tablename2 where <table2>tablename2.column2 = 'xyz'); True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update <table> set column1 = '' where <table>.id = (select id2 from <table2> where <table2>.column2 = 'xyz'); True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update tablename set column1 = '' where tablename .id = (select id2 from tablename2 where tablename2.column2 = 'xyz'); True, this is pointless for the most examples. But finally, I came to the following statement and it works fine:
update <table> set column1 = '' where <table>.id = (select id2 from <table2> where <table2>.column2 = 'xyz');