General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Right outer join from 3 tables
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only