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?