7
Reply

find distinct records from two table

Sumit Kumar Sinha

Sumit Kumar Sinha

Jan 15 2013 5:35 AM
1.1k

Table Product

PID(PK)Name

1Mobile
2Laptop
3Fashion


Table Coupons

IDPIDCity

12Bangalore
23Pune
3 2Mumbai
41Bangalore
52Mumbai


I want to select distinct City name records joining two tables
(if i have five different city then its one one record from each city).
Pl'z suggest me, how can i fetch this records.
I trired using distinct keyword to fetch records but i am unable to find desire output....

Answers (7)
Next Recommended Forum