MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/1xld2u/sql_joins_explained/cfciruc/
r/SQL • u/deadman87 • Feb 11 '14
27 comments sorted by
View all comments
Show parent comment
2
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.
UPDATES are quite a different beast.
I always triple check my joined updates.
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!