2,299
edits
Changes
no edit summary
{{Banner-UnderConstruction}}
=Overview=
In this process specific exercise, you will explore “joining” multiple tablescreate a query that uses the company table and the contact table.
1. Click the 9-square menu icon on the top right of your page.
:: [[File:Company and contact inner join.png|250px|border]]
* The '''Organizations '''recordset will report on company information that you have entered into the system, including all organization-specific [[Custom Fields]] that are related to organizations.
* The '''Contacts '''recordset will report on all contacts ''outside ''of your organization (although this does not automatically mean that they are [[External|}external]] [[User|users]]). This table will include all contact-specific and [[User Role|role]]-based [[Custom Fields]].