here is an example where I have explained full join output and how you can test. This should help test it on our data : Data missing from a full join - #7 by Roger
here is an example where I have explained full join output and how you can test. This should help test it on our data : Data missing from a full join - #7 by Roger