Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 getting multiple records into single record

Author  Topic 

sqlteam_rama
Starting Member

1 Post

Posted - 2011-02-20 : 09:36:58
I have a table
education
eduid candidateid degree
1 200 mca
2 200 be

another table personal
candidateid name
200 xxx


i want to get output as

candidateid name degree.Please let me know how to write the query
200 xxx mca,be

ram

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-02-20 : 09:49:00
see this thread
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -