For example, let’s look at the following set of phone numbers with two Home phone types:
OLD WAY: Using the SQL query with joins to the address will only show you one of each type that is Active. Notice that the new phone “123-456-7890” does not appear in the results.
NEW WAY: Using the SQL with the direct links from RECORDS to PHONES will display all entries.
So in summary, only the first active value for each phone type will be linked to the old address tables (CONSTIT_ADDRESS and CONSTIT_ADDRESS_PHONES). All others will be linked the new way as RECORDS to PHONES links only.