Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.24 KB | None | 0 0
  1. Old_data contains around 60,000 records and fields "EMAIL"
  2. New_data contains around 90,000 records and fields "EMAIL" "WHITE_NO"
  3.  
  4. SELECT * from Old_data, New_data SET New_data.WHITE_NO = 'true' WHERE old_data.EMAIL = New_data.EMAIL
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement