Defining joins for select files
You might require data from more than one iMIS table for export. For example, you might need FULL_NAME and COMPANY from the Name table and TYPE=‘DUES’ and BALANCE from the Subscription table. Since there is no membership data in the Subscription table, you must access the Name table. To use data from two or more tables, you must join them.
To join files (tables) is to specify which fields are equivalent so the files can relate to each other correctly, record-by-record. In effect, joining glues the files together for the export process. The most common joins in iMIS center on member ID numbers. A join across three tables might look like the following:
Name.ID = Activity.ID Name.ID = Subscription.ID