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.

Related Topics

Adding a Global Join

Adding a Local Join

Joining Tables



What's New in this Release


For a list of new features, see the What's New In This Release topic.

Contact us:

This documentation was developed by Infor CRM User Assistance. For content revisions, questions, or comments, contact the Infor CRM writers at