Link Left Outer Join (Magic xpa 3.x)
Magic xpa can implement the Link definition as a Left Outer Join if both the Main and Joined tables are SQL tables from the same database. Also, the relationship between the Main and Joined tables must be a many-to-one relationship: at least one main record that links to either one or no supplemental records in the joined table. A Link Left Outer Join definition joins a record from the Main Source in Magic xpa to either a matching record in the joined table, or a set of null values returned if no matching record is found.
When a matching row is found, a true value is returned. If no matching row is found, a false value is returned.
Link Left Outer Join Operation Syntax for Available Databases