Scenario: Two tables, PARENT table has a foreign key, and a Lookup table which contains the associated primary key. You want to see every record in the PARENT table even if there is no matching value in the Lookup table, i.e. an Outer join.
Outer Join in Access: “Include all records from ‘PARENT’ and only those records from ‘Lookup’ where the joined fields are equal.”
Outer Join in SAS Enterprise Guide: “All rows from the PARENT table”
Outer Join in TDA: “Select all rows from Lookup”
Is this by design or changed in a later version of TDA? I am using 18.104.22.1683 currently.