3 Replies Latest reply: Jan 30, 2013 12:47 PM by user11199856 RSS

    Querying across tables and update new column

    user11199856
      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.

      thanks