Re: Many-to-many query question

jonck_at_vanderkogel.net (Jonck van der Kogel) wrote in message news:<28a69e7c.0402011530.2f493fc1_at_posting.google.com>...

[...]

> Now let's say I wan't to query for all the authors of book #1.
> Naturally this is very simple to do, but every way I think of returns
> two rows, whereas what I am looking for is to get this information in
> a single row. Can this be done?
>

In general no. What you are looking for is some kind of transpose operation and that is normally handled in the application or in the client layer. You can make a query that handle n authors, but it will break for n+1 authors.

HTH
/Lennart Received on Mon Feb 02 2004 - 06:19:29 CET