Openedge Equivalent of SQL's outer apply

I have two tables I need to "join" together.

Employment Table

First Middle Last ID
------- ------- ------- ------
John Manly Doe 12345


Job Responsibilities

ID fkEmploymentID Title Main Role
--- ---- ----- -----
1 12345 Worker bee True
2 12345 Honey Sucker False


So if I do a typical join, I'd get two records. I only want one record with the main role (true).

Normally in SQL I'd do and Outer apply / select to take the record I want. However, this doesn't seem to be supported on Openedge.

This is OpenEdge 11.1.

Continue reading...