D
DaBlue
Guest
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...
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...