October 15th, 2003, 09:01 AM
sql query question
I'm trying to get the right output for a query and I can't seem to do what I want to... wondering if I'm just missing something.
I have 2 tables, for simplicity sake we will say they're like this
Books that has columns of ISBN and Title
Authors that has columns of ISBN and Authors
Books has the following data:
1234 Some Title
Authors has the following data:
1234 John Smith
1234 Bill Jones
So when I join these 2 tables I get 2 rows, because my book "Some Title" has 2 authors. What i want to retrieve is 1 row that lists both authors like this:
ISBN Title Authors
1234 Some Title John Smith, Bill Jones
Is there some way to do this w/ a simple query?
October 15th, 2003, 10:40 AM
October 15th, 2003, 10:45 AM
well then how about a not so simple query? a push in the right direction would be more than helpful.
would it be any easier in oracle? the tables originate in oracle but somewhere in the process get transfered to mssql.
October 15th, 2003, 11:01 AM