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 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.