Left-table items will be in the results whether they have a match or not.

Right-table items will appear only if they have a match in the left table.