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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net