re: SQL 101: All about SQL JOINs VIEW POST

VIEW PARENT COMMENT VIEW FULL DISCUSSION
 

Aleksei …

FULL JOIN will do basically a LEFT JOIN and a RIGHT JOIN, correct?

Yes, you are correct in that I have never found too many practical uses as … no databases would normally have this situation in production use. But I still think it should be in the list.

There ARE limited cases like linking all reps to all products and finding which reps have NOT sold what products.

Dale

The beauty of development ... there is never a right and wrong! Some things are logical until the day that they aint ... and vice-versa.

Dale

code of conduct - report abuse