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