2,299
edits
Changes
no edit summary
{{Banner-UnderConstruction}}
==Overview==
This article will explain how to use the the '''Outer Join Join'''option for when you are creating a [[Reports|report]] with multiple [[Report Recordsets|recordsets]]. This feature is applicable only for reports with '''[[Classic Report Builder - Column Settings|Builder Type - Classic Classic]]'''(as opposed to our more recent and recommended option, the the '''[[Report Builder (Neo)|Neo Report Builder]]. ''' In a nutshell, the '''Outer Join''' option modifies your report-building so that your report query will display columns from multiple tables, even without matching records. The records that do not match with both tables will simply show up blank. ===Inner vs Outer Join===There are two types of '''Joins '''that can be used in the '''Classic Report Builder '''to connect recordsets in a report:
{| class="wikitable"
|}
===Enabling Outer Join===
The '''Outer Join '''connecting functionality (and to connect multiple tables to a report in general) is accessed from the '''Edit Report '''page in the second tab labelled '''Recordsets.'''
1. Click on the 9-square menu icon on the top right of your page.
:: {{Icon-Menu}}
2. Under the heading '''Tools, '''select '''Reports.'''
3. Click on the '''pencil icon '''next to the report that you would like to edit.
4. Click into the second tab labelled '''Recordsets.'''
:: [[File:Recordsets inner outer join.png|thumb|none|600px|border|Outer Join option available for fields found in the Recordsets tab]]
===Example of Outer Join for Reports===
In this article you will modify the query to display companies where there are no contacts.
