User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 403,035 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,867 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our MS SQL advertiser: Programming Forums
Views: 1047 | Replies: 2
Reply
•
•
Join Date: Sep 2006
Posts: 104
Reputation: bhavna_816 is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
bhavna_816 bhavna_816 is offline Offline
Junior Poster

Get unique value in INNER JOIN in SQL server 2005 query

  #1  
May 19th, 2008
I am joining two tables with INNER JOIN and I am getting duplicate entries.
I used DISTINCT but its not working.
Do we have some other keywords for the same?


Thanks in advance,
AddThis Social Bookmark Button
Reply With Quote  
•
•
Join Date: May 2008
Posts: 53
Reputation: lich has a little shameless behaviour in the past 
Rep Power: 0
Solved Threads: 4
lich lich is offline Offline
Junior Poster in Training

Re: Get unique value in INNER JOIN in SQL server 2005 query

  #2  
May 19th, 2008
what is the tables you joining and what are the entries u getting again after joining. if u can make another field and put it as pk in that new table
Reply With Quote  
•
•
Join Date: Apr 2008
Posts: 295
Reputation: tesuji is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 41
tesuji tesuji is offline Offline
Posting Whiz in Training

Re: Get unique value in INNER JOIN in SQL server 2005 query

  #3  
May 19th, 2008
If you expect serious answer, you have to show your exact tables definitions first.
Reply With Quote  
Reply

•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode

•
•
•
•
ad ad server ad serving advertising ajax architecture asp backup beta business centro crash daniweb database dell developer development doubleclick enterprise google hacker hyper-v internet linux longhorn mail management studio 2005 microsoft mmorpg msdn news novell office open qmail red hat rhel scsi security server server 2008 smtp software sql survey upgrade vista vmware windows workspace
Other Threads in the MS SQL Forum

Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 11:08 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC