Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- UPDATE table2
- SET column2 = table1.column2
- FROM table2 INNER JOIN table1 ON table2.column1 = table1.column1
- SELECT *
- FROM table1
- WHERE table1.column1 NOT IN(SELECT column1 from table2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement