I want to get data from 3 tables. Want all records in table 1, records in table 2 that are in
table 1 and records in table 2 that are in table 1. Because of way data was created all 3
tables have the same field names for equivalent fields. I assumed I need to use a right
outer join. For table 1 and 2 I used

select 1.a, 1.b, 1.c, as x, 2.c as y from 1 ;
join 2 ;
on 1.a = 2.a and 1.b = 2.b ;
into cursor c1

This gives records in table 1 and table 2, can do a similar request for table 1 and 3.
How do I records in 1 with matching records in table 2 and matching records in 3?

If possible I would also like null fields to be returned as blanks.