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?