[stackoverflow] [progress Openedge Abl] Sql: Join Four Tables Without Duplicates And Losing...

[azmd108]

I want to join four tables, without losing data and without duplicates.

Im using ODBC on a Progress-OpenEdge-Database(FULL OUTER JOIN is not working).

TableA
Anl1234
Anl5678
Anl9000
Anl8000

TableB
Anl1234 100
Anl1234 200
Anl5678 50
Anl8000 10

TableC
Anl1234 Ref1
Anl1234 Ref1
Anl1234 Ref2
Anl9000 Ref3

TableD
Ref1 140
Ref2 100
Ref3 500

Result:
Anl1234 100 140
Anl1234 200 100
Anl5678 50 NULL
Anl9000 NULL 500
Anl8000 10 NULL


What is the best way of doing this in one query?

Continue reading...