how to use union in sql server?

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

0	Plz try this: http://blog.sqlauthority.com/2008/10/15/sql-server-introduction-and-example-of-union-and-union-all/ Chandru_ra, if this helps please login to Mark As Answer. \| Alert Moderator

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

0	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

0	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

0	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

0	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

0	hi refer nested http://www.upsizing.co.uk/Art17_UnionQuery.aspx Chandru_ra, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts