Advertisement
Guest User

Untitled

a guest
Apr 20th, 2014
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. UPDATE table2
  2. SET column2 = table1.column2
  3. FROM table2 INNER JOIN table1 ON table2.column1 = table1.column1
  4.  
  5. SELECT *
  6. FROM table1
  7. WHERE table1.column1 NOT IN(SELECT column1 from table2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement