I took 3 select queries and did a UNION ALL to get a FULL outer join. I see some records repeating, 3 times to be exact. I presume the first occurrence is from the INNER join, the second from the LEFT outer join and the third from the RIGHT outer join.
How can I get these repeating records to appear only once?
In the case of all other records, i.e. LEFT outer join that does not match with the "Right" table and vice versa, it seems that they are appearing only once, which is fine.
I have tried the GROUP BY statement, then listed all fields after each query. This didn't work. I tried the GROUP BY statement just once after all 3 queries and still this did not work.