Lets say i have 2 tables 'book' and 'author'
If a book has mulitiple authors I would like my query to return book and authors in one row like:
1 "bookA", "authorA, authorB"
2 "bookB", "authorA, authorC"
3 "bookC", "authorD"
My real query is more complex, but it is this concept that would help me out. Can it be done?
(I've also tried to return the subqueries result as XML and cast that to a string, but I don't think SQL server 2000 supports an XML returning query within an ordinary record returning query)