This content has been marked as final. Show 3 replies
user11199856 wrote:How do I ask a question on the forums?
Hi very new to SQL.
I have 30 million rows in table_a in column_1 and 1 million rows in table_b in column_2.
I want to simply query all the entries in table_b in column_2 to see if they exist in table_a in column_1 then write them to table_b column_3 with a 'YES' value.
SQL and PL/SQL FAQ
SET COLUMN_3 = 'YES'
WHERE TABLE_B.COLUMN_1 IN (SELECT COLUMN_1 FROM TABLE_A);
user11199856 wrote:effectively COLUMN_3 is a 'computed' value; which should NEVER be stored within any static table
since the values in TABLE_1 could change & making the value in COLUMN_3 to be incorrect.