Changes

Jump to: navigation, search

Reports Based on Multiple Tables - Overview

193 bytes added, 17:27, 8 July 2019
no edit summary
There are two types of joins supported in [[SmartSimple]] – inner joins and outer joins.
:* An '''inner {| 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 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 companyorganization.:** If no match is found, the record from the company is will not be included in the report results.:** If multiple results are found in the contact table, the company information will be repeated.An '''|- !| Outer Join || The outer join''' is very different from an inner join. Instead of limiting results to those in from both tables, it limits results to those in the "left" company organization table.:** This means that if there are no records in the contact organization table, a row in the report will still be returned for that company, but with NULL values for each column from contact.Only use the outer join if you would still like all results (regardless of matching records with the other table) to show up.  |- |} 
1. Open the '''Report Builder '''by clicking on the four-square icon above the name of the report.
:: [[File:Report builder icon.png|border]]
 
:: 2. Add the '''following fields''':
:: [[Image:Reps98.png]]
2,299
edits

Navigation menu