re: SQL 101: All about SQL JOINs VIEW POST

TOP OF THREAD FULL DISCUSSION
re: My wild guess would be that’s because FULL JOIN is an evidence of a design flaw. If you find yourself doing FULL JOIN your database structure requi...
 

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