Join types

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

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

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