left join

left join

References in periodicals archive ?
FROM Products INNER JOIN (Orders LEFT JOIN qOrderBalance ON Orders.
LEFT JOIN includes all records from the first table (even if there are no matching values in the corresponding field of the second table) and just those records from the second table where the values match the corresponding field.
The nested LEFT JOIN clause-(Orders LEFT JOIN qOrderBalance ON Orders.