2,299
edits
Changes
no edit summary
{{SeqReportPageHeaderBanner-UnderConstruction}}
In this process specific exercise, you will explore “joining” multiple tablescreate a query that uses the company table and the contact table.
:: [[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]].
8. Scroll down to the bottom of the page and click '''Save.'''
=Inner and Outer Joins=
There are two types of joins supported in [[SmartSimple]] – inner joins and outer joins.
This is the most common type of join used, and is the default join type when you [[Adding a Table to a Report|add tables to a report]].
When you join the company table organization and the contact table with an inner join, the report will find the matching record(s) from the contact table related to each organization. If no match is found, the record from the company will not be included in the report results. If multiple results are found in the contact table, the companyinformation will be repeated.
3. '''Build''', '''save''', and '''preview''' the report.
:: [[Image:Reps97.png]] ::* The company name, city, and state information is displayed from the company table for each matching record from the contact table. ::* No company details will be displayed if there are no contacts.
{{PrevNextStart}} [[Creating a Public – Internet Enabled Report]]{{PrevNextMid}} [[Using an Outer Join]]{{PrevNextEnd}}
[[Category:Reports]]