[stackoverflow] [progress Openedge Abl] Outer Apply To Select A Single Record

[DaBlue]

I'm trying to use OpenEdge sql connector to connect pull an employee's title. The employee can have multiple titles and I want to prevent multiple rows showing up on the main query. In MSSQL I'd use an outer apply to do this, but I'm having difficulties using an outer apply in Progress/Openedge.

The part of the query in question is here:

OUTER APPLY (
SELECT TOP 1 * FROM "PUB"."ASSIGNMENT"
WHERE "PUB"."ASSIGNMENT"."ID" = "NAME"."ID"
) title


This gives me a syntax error at "OUTER APPLY (select top 1......"

Anyone know how this is done with the SQL connection to ProgessDB?

Continue reading...