Select distinct

Jun 26 2011 8:11 AM


I have 3 tables.

1st table contains suppid,suppname,suppplace,supppho,suppmob named as supplier.

2nd table cotains itemid,itemname,itemcode,qty,price named item.
3rd contains purno,suppid,itemid, purqty,purrate,purdate named as purchace.

I want to select suppname,itemcode,itemname,purdate,purqty,purrate from purchace,item,supplier where purno="###" here i want suppname,purdate as distinct. how we write this as query?

Answers (3)