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 warning here... if there is no match, then the "NULL" value is inserted into that spot. Hope it helps, K -- Kay Bowen Tec-Masters, Inc. Advanced Studies and Research Center --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php