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.
| Author |
Topic |
|
kieran5405
Yak Posting Veteran
96 Posts |
 Posted - 2007-11-21 : 11:50:38
|
| Hi,Each row in the table 'Application' can have multiple related rows in the 'Comments' table.SELECT d.Address, Comments.commentFROM Application as d Left Join Comments on d.ID = Comments.DevID where d.ID = 39In the above example, when I run the query on the application that has 2 comments related to it...I get 2 rows returned...which is how it should be. But I really need to just get 1 row and some how have the 2 comments appended together in this row. Is this in anyway possible through some sort of join etc...Thanks for all help... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
kieran5405
Yak Posting Veteran
96 Posts |
Posted - 2007-11-21 : 12:43:01
|
| cheers...worked great... |
 |
|
|
|
|
|
sql and multiple related rows issue