This discussion is archived
3 Replies Latest reply: Jan 30, 2013 10:47 AM by 839509 RSS

Querying across tables and update new column

839509 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points