Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
find distinct records from two table
Sumit Kumar Sinha
Jan 15 2013 5:35 AM
1.1k
Reply
Table Product
PID(PK)
Name
1
Mobile
2
Laptop
3
Fashion
Table Coupons
ID
PID
City
1
2
Bangalore
2
3
Pune
3
2
Mumbai
4
1
Bangalore
5
2
Mumbai
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....
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
Sql Query
SQL SERVER 2000