[PHP-DB] MySQL SELECT help From: Chris Lee (lee <email protected>)
Date: 11/10/00

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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>