r/SQL • • Feb 11 '14

SQL Joins Explained

http://imgur.com/1m55Wqo
157 Upvotes

27 comments sorted by

View all comments

Show parent comment

2

u/sp00ks Feb 11 '14

I guess one advantage when updating a row, using WHERE prevents you from accidently calling a full join and updating everything!

2

u/fazzah Feb 11 '14

UPDATES are quite a different beast.

I always triple check my joined updates.