2,299
edits
Changes
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 for reports with '''[[Classic Report Builder - Column Settings|''''''Builder Type - Classic]] '''(as opposed to our more recent and recommended option, the '''[[Report Builder (Neo)|Neo Report Builder]]. '''
{| class="wikitable"
|-
!|Inner Join
|| The '''inner join''' displays the intersection between the two selected tables.
This is the most common type of join used, and is the default when you [[Adding a Table to a Report|add tables to a report]].
|-
!| Outer Join|| The '''outer join''' is very different from an inner join. Instead of limiting results to those from both tables, it limits results to those in the "left" organization table.
For example: Assume that you have used the outer join to connect the organization and contact table. If there are no records found in the organization table that match with contacts, a row in the report will still be returned for that organization, but with NULL values for each column taken from contact fields.
Only use the outer join if you would still like all results (regardless of matching records with other table) to show up.
|}
