Skip to Content
0
Former Member
Jan 12, 2011 at 11:00 PM

Full Outer Join

135 Views

I am having trouble creating a full outer join.

I am using an ODBC driver with a progress database. The Full Outer Join is greyed out. I tried using the following command:

SELECT "OrderRel1"."PartNum", "JobHead1"."PartNum"

FROM "MFGSYS"."PUB"."OrderRel" "OrderRel1" FULL OUTER JOIN "MFGSYS"."PUB"."JobHead" "JobHead1" ON "OrderRel1"."PartNum"="JobHead1"."PartNum"

However i got the following error message:

Failed to retrieve data from database.

Details: HY000:[DataDirect][ODBC Progress OpenEdge Wire Protocol Driver][OPENEDGE}Sorry, operation not implemented yet (7484) [Database Vendor Code: -20024]

IS there another way to create the outer join?