how to use union in sql server?

Posted by Chandru_ra under Sql Server on 7/6/2011 | Points: 10 | Views : 2002 | Status : [Member] | Replies : 7
Dear all

now am using to tables one forums and response this table using inner join query but repeated response display..

how handle this problem
am post in one forum and then response for two ro three peoples. but display in one time.. now only displayed in more times this query..

code:
select F.forumID,F.Author,F.forumTitle,F.forumDesc,F.Category,F.Points,F.Images,F.Dateofpost,Convert(VARCHAR(10),F.Dateofpost,101) as Jdate from tblForum F inner join tblForumResponse s on F.forumID=s.forumID where Status='Approved' order by s.Dateofpost desc



Advance thanks to all

chandru


Responses

Posted by: Vforvijay on: 7/6/2011 [Member] Starter | Points: 25

Up
0
Down
Refer this link...

http://www.w3schools.com/sql/sql_union.asp

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Navalemanoj0405 on: 7/6/2011 [Member] Starter | Points: 25
Posted by: Teena on: 7/6/2011 [Member] Starter | Points: 25

Up
0
Down
haiiiiiiiiiii

Refer this link
http://msdn.microsoft.com/en-us/library/ms180026.aspx

Regards
Teena

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Lakn2 on: 7/6/2011 [Member] Starter | Points: 25

Up
0
Down
what error did you get from the given query .

Thanks&Regards
LakshmiNarayana Nalluri.

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Chandru_ra on: 7/6/2011 [Member] Starter | Points: 25

Up
0
Down
No error display..

display for more then time display in the forums..


chandru

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Susanthampy on: 7/6/2011 [Member] [MVP] Bronze | Points: 25

Up
0
Down
Hi,

use this link,

http://msdn.microsoft.com/en-us/library/ms180026.aspx

Regards,
Susan

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vilasgite080 on: 7/6/2011 [Member] Starter | Points: 25

Up
0
Down
hi
refer nested
http://www.upsizing.co.uk/Art17_UnionQuery.aspx

Chandru_ra, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response