3 Replies Latest reply on Jan 30, 2013 6:54 PM by sb92075

    Querying across tables and update new column

      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.