I have a database with a 1:n relationship as follows:
My client wants me to export these linked records into an Excel file in
the following format.
item.fld1 item.fld2 ... item_info.fld1 item_info.fld2 ...
item_info.fld1 item_info.fld2 ..
ie. each item and all the records that make up its info together in a
single Excel row.
I'm using an excel library that accepts a SELECT as input and generates
an XLS file with the records as output. I'd like to use this where
possible. However I don't know if it's possible to write a SELECT that
compresses a 1:n relationship into a single row. Is this possible, and
if yes, could someone show me how? Or could you suggest another way in
which I could achieve the above required output?
Operator: "So what do you need? Besides a miracle."
Neo: "Guns. Lots of guns."
-- The Matrix