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!