2,299
edits
Changes
no edit summary
=Overview= {{SeqReportPageHeader}| 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]]. For example: When you join the organization and 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 company information will be repeated. |-!| 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. |}
In this article you will modify the query to display companies where there are no contacts.
[[Image:Reps96.png]]
2. Open the '''Query Builder'''.
[[Image:Reps95.png]]
The company records with no contacts are displayed at the top of the list.
=Locating Null Records=
You can also use this technique to restrict the results to records where there are '''NO''' matching records in the joined table.
[[Image:Reps94.png]]
2. '''Build''', '''save''', and '''preview''' the report.
[[Image:Reps93.png]]
You can hide the two columns that are not displaying any date by clicking the '''Show''' check box for these two columns.
