Skip to Content
0
Oct 07, 2005 at 04:30 PM

SELECT with outer joins - how to?

26 Views

I need to select from 3 tables A,B and C. It has to be an outer join from table A, i.e. I need ALL records from A.

"A" can have multiple corresponding records in B and we need them all. Entries from B has exactly 1 corresponding record in C.

I have to get data in ONE select statement. Can you help with the syntax?

Example of data:

A: WERKS=1234

B: WERKS=1234, OBJID=100000

B: WERKS=1234, OBJID=100001

B: WERKS=1234, OBJID=100002

C: OBJID=100001, COSTCTR=0023

Thanks a lot.