Guidelines for Using Joins

Use the following guidelines when creating table joins in Infor CRM:

On a view that shows fields from multiple tables, use Left joins. If you use Inner joins and there is no data in one of the tables, NO DATA will appear in ANY field in the view.
In a group, use Inner joins for the tables used in Conditions. This way, you will only get records that meet your criteria. However, you may want Left joins for the tables used in the Layout so all records that meet your Conditions are included, even if there is no data in one of the tables.

By default, the ADDRESS table is joined to the ACCOUNT table via an Inner join. Do not change the properties of this join.