how to query this?

[thesti]

hi,

i have three tables:

supplier : supplier_code, supplier name
delivery : supplier_code, product_id, date
product : product_id, product_name


let's say that i have 7 kind of product
how to show the name of the supplier who has delivered all kinds of product?


thank you very much

[gpl]

The simple solution, showing what product was delivered by which supplier would look like this

Select DISTINCT
  s.supplier name,
  p.product_name
From supplier s
Inner Join delivery d on s.supplier_code=d.supplier_code
Inner Join product p on d.product_id=p.product_id

"how to show the name of the supplier who has delivered all kinds of product?"
Im not sure quite what you mean by this -- do you mean suppliers who supplied more than one product ?

Graham