Sumit Kumar Sinha

Sumit Kumar Sinha

  • NA
  • 159
  • 79.7k

find distinct records from two table

Jan 15 2013 5:35 AM

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)