Neil,
I did a quick test of your data and this is what I got to work.
SELECT item.item, titles.title FROM item LEFT JOIN titles ON
item.title_id = titles.title_id;
The left join selects all the items from the 'left' table even if there
are no matching entries in the 'right' table. A bit of a w
Hi all,
I have two tables (Titles(title, title_id, ...), Item(item_id, title_id,
...)) which have a common field (title_id) which I intend to use to join the
tables together. However, some Items have title_id's which do not match any
title_id in the Titles table, don't ask me why it's someone els
