Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005
Hi All,
 
I am facing some problem in a query. I have two table tbl_summary and publishinfo.
I want to display data through join from both tables. Display data must be multiple same record display one record and which that stored single record then single record also displayed. In both tables common are artid and catid. publishinfo table only contains artid and catid columns. All details are stored in tbl_sumary table.
 
Please suggest and help me.
 
Thanks
Narendra kumar
Posted 8-Oct-12 23:09pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

To single instance of record in sql you can use Distinct key word
The below link will help you
 
http://blog.sqlauthority.com/2007/03/29/sql-server-difference-between-distinct-and-group-by-distinct-vs-group-by/[^]
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 490
1 Gihan Liyanage 338
2 ChauhanAjay 180
3 Vinay Mistry 160
4 Sergey Alexandrovich Kryukov 153
0 Sergey Alexandrovich Kryukov 9,011
1 OriginalGriff 7,941
2 CPallini 2,603
3 Richard MacCutchan 2,121
4 Abhinav S 1,928


Advertise | Privacy | Mobile
Web03 | 2.8.140827.1 | Last Updated 9 Oct 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100