MySQL SELECT help

I have three tables table product =========== stockno name table product_category ================== stockno category table product_image ================ stockno data select * from product ================ 1234 truck select * from product_category ======================== 1234 automobile select * from product_image ====================== 1234 file1.jpg select * from product, product_category, product_image ============================================ 1234 truck 1234 automobile 1234 file.jpg see thats fine, but now what I want is if there are no entries in one of the tables to still return the data it knows about. ie. select * from product ================ 1234 truck select * from product_category ======================== 1234 automobile select * from product_image ====================== Empty Set select * from product, product_category, product_image ============================================ 1234 truck 1234 automobile NULL NULL Can this be done ? Chris Lee Mediawaveonline.com