Thread: Full outer join with distinct
05-21-03, 10:11 #1Registered User
- Join Date
- Mar 2003
Unanswered: Full outer join with distinct
I've got two tables that I wish to join. There are 6 records in each, of which five match with one mismatch on either side. If I use a full outer join, I am not able to see seven records, only 6. Even if use dont use distinct, I still dont see the result I require.
Anyone who can help will be greatly appreciated!