Click here to Skip to main content
12,243,738 members (44,158 online)
Rate this:
 
Please Sign up or sign in to vote.
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 9-Oct-12 0:09am

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
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160426.1 | Last Updated 9 Oct 2012
Copyright © CodeProject, 1999-2016
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