[Firebird-odbc-devel] Is this a job for ROLLUP?

[Maury M. <mau...@gm...>]

I have a table called PARTS and another called KITS. Joining the two is a fkey table, KITPARTS. A single part can be in more than one kit. I'd like to make a report like this...

KIT                  PARTS
Kit 1                Part One
                        Part Two

Kit 2                Part Two
                        Part Three

Normally I'd do this in code, but for this project I'm trying to keep the SQL in the SQL...