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.
I was plain wrong on the subject.
The beauty of development ... there is never a right and wrong! Some things are logical until the day that they aint ... and vice-versa.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.