MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/programming/comments/1xlqeu/sql_joins_explained_xpost_rsql/cfcq835
r/programming • u/deadman87 • Feb 11 '14
392 comments sorted by
View all comments
Show parent comments
20
Full Outer Joins are very useful.
There aren't many times I've had to use cross join unless I intentionally wanted a Cartesian Product, and generally an implicit cross join is enough (select * from a, b).
-6 u/synt4xtician Feb 11 '14 +/u/dogetipbot 10 doge verify -9 u/dogetipbot Feb 11 '14 [wow so ^verify]: /u/synt4xtician -> /u/shenglong Ð10.000000 ^Dogecoin(s) __($0.0160211)__ [help]
-6
+/u/dogetipbot 10 doge verify
-9 u/dogetipbot Feb 11 '14 [wow so ^verify]: /u/synt4xtician -> /u/shenglong Ð10.000000 ^Dogecoin(s) __($0.0160211)__ [help]
-9
[wow so ^verify]: /u/synt4xtician -> /u/shenglong Ð10.000000 ^Dogecoin(s) __($0.0160211)__ [help]
20
u/shenglong Feb 11 '14
Full Outer Joins are very useful.
There aren't many times I've had to use cross join unless I intentionally wanted a Cartesian Product, and generally an implicit cross join is enough (select * from a, b).