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
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
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