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...