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

Related Topics

Joining Tables

Joining Tables Example

 

Tell us how we can make the Help better.