Changes

Using an Outer Join

269 bytes added, 20:30, 9 July 2019
no edit summary
==Overview==
This article will explain how to use the '''Outer Join''' option for when you are creating a [[Reports|report]] with multiple [[Report Recordsets|recordsets]]. This feature is applicable only This article will explain how to use the '''Outer 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]] '''(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.
 
210 + 200 + 250 = 660 + 100 = 660 +
:: {{Icon-Menu}} 
4. Click into the second tab labelled '''Recordsets.'''
 
In this article you will modify the query to display companies where there are no contacts.
2,299
edits