Join query didnt displayed correct results????

[niroshan]

Hi,
I have two tables called "products" and "suppliers". i want to display all the products from the products table with the corresponding supplier name. this is the table structure,

supplier

supId (primary Key)
supName

products

productId (Primary key)
name
supId (forign key)

my problem is some of the supId`s in the products table are NULL. so now i can not use the simple query like the one below,

select products.name,supplier.supName from products,supplier where products.supId=supplier.supId

i tryied all the possible ways i no but still the query failed.

Does anyone no how to write this query???

thanx in advance
Niroshan

[Roger_Ramjet]

You use a LEFT JOIN to list ALL products and if there is no supplier then those columns are returned as NULL values.

$sql = "select products.name,supplier.supName from products LEFT JOIN supplier USING (supId)";

[niroshan]

hi Roger Ramjet,

I tried u r code and it WORKED.. 🙂

thank you very much for u r help..I really appreciate it..
i worked 3 days on this query... U gave me a good support..

thanx a lot,

Regards,
niroshan