|
kieran5405
Yak Posting Veteran
Ireland
92 Posts |
 Posted - 11/21/2007 : 11:50:38
|
Hi,
Each row in the table 'Application' can have multiple related rows in the 'Comments' table.
SELECT d.Address, Comments.comment
FROM Application as d
Left Join Comments on d.ID = Comments.DevID
where d.ID = 39
In 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...
|
Edited by - kieran5405 on 11/21/2007 11:52:16
|
|
sql and multiple related rows issue
