Loading

Select distinct

Shyja Abraham

15y2.2kSQL

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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

pooja shete15y ago
you can use group by suppname and purdate
0
Vilas Gite15y ago
hi Shyja
please use joins.

http://msdn.microsoft.com/en-us/library/ms191430(v=sql.90).aspx
-------------------------------------------------------------------

If this reply hepls your post…then "MARK AS ANSWER"!

0
Morcos Adel15y ago
i think you can add distinct before any column name
0