Join Types

Inner: Include only records where the joined fields from both tables are equal. Example

Left: Include ALL records from the Parent Table and only those records from the Child Table where the joined fields are equal. Example

Right: Include ALL records from the Child Table and only those records from the Parent Table where the joined fields are equal. Example