Guidelines for using joins
Use the following guidelines when creating table joins in Infor CRM SLX:
- On a view that displays fields from multiple tables, use Left joins. If you use Inner joins and there is no data in one of the tables, no data is displayed in any field of the view.
- In a group, use Inner joins for the tables used in conditions. Therefore, you can receive only records that meet your criteria. However, you may require Left joins for the tables used in the layout for all records that meet your conditions are included, even if there is no data in one of the tables.
Note: By default, the ADDRESS table is
joined to the ACCOUNT table
through
an Inner join. It is
recommended
not
to change the properties of this join.