User`s guide

Database Explorer
7-103
rows in suppliers that do not have a match with any row in producttable are padded
with null values in the final result.
In the Data Preview, there are 11 rows that match the query conditions. There is a
null in productDescription and a NaN in unitCost because the supplier The Great
Teddy Bear Company supplies no products. If the condition type is set to INNER JOIN
instead of LEFT JOIN, this row does not appear in the final result.
From the SQL Criteria pane, click + at the end of the LEFT JOIN condition
to add a query condition. Change the first combo box to WHERE, the second to