find distinct records from two table

so then , you need to use:

  SELECT DISTINCT C.City, C.PID, P.Name
  FROM Product AS P
  INNER JOIN Coupons AS C ON C.PID = P.PID
  ORDER BY C.City

____________________________________
City PID Name
____________________________________
Banglore   1 Mobile   
Banglore   2 Laptop   
Mumbai     2 Laptop   
Pune       3 Fashion  

So, in this way you get rid of the one duplicate row "Mumbai    2   Laptop" in comparison to previous result.

You can't get rid of Banglore column duplicacy because full row wise "Banglore   1 Mobile" and "Banglore   1 Laptop" are different.

As Jignesh said "Distinct can not be applied to only few columns it is always applied to whole column set means all column which are used with "select"."

Hope it would help you.

"Hemant Srivastava" I want to distinct records city wise.

Eg:

City         PID         Product

Bangalore  2         Laptop

hi,

The SQL DISTINCT clause allows you to remove duplicates from the result set. The SQL DISTINCT clause can only be used with SQL SELECT statements.

so Distinct can not be applied to only few columns it is always applied to whole column set means all column which are used with "select".

try following two query, it return different result set.

select Distinct City,P.Name from #product p
join #Coupons c on c.PID = p.PID

select Distinct * from #product p
join #Coupons c on c.PID = p.PID

hope this will help you.

Please show me some code that you have tried. Which controls you are using? And which platform you are working windows or asp.net.?

You should use joining for selecting records from distinct records.

and if you want the query please show me the output show that i can make the query for you.