Given three basic tables. An fmr table which has Field Maintenance
Reports, a Seat table and a hanging or glue table to map Seats to FMRs.
[See below]
How do I get all the Seats to be in a single row with the FMR data?
If I make this kind of query, they come in as separate rows:
SELECT
GROUP_CONCAT() ?
And group by id_fmr ?
JW
On Wed, Sep 29, 2010 at 2:38 PM, Daevid Vincent dae...@daevid.com wrote:
Given three basic tables. An fmr table which has Field Maintenance
Reports, a Seat table and a hanging or glue table to map Seats to FMRs.
[See below]
How do I get all the
BRILLIANT
SELECT
`id_fmr`,
`fmr_number`,
`fmr_system`,
`fmr_station`,
`created_ts`,
GROUP_CONCAT(`seat`)
FROM `fmr`
JOIN `fmr_has_seat` USING (id_fmr)
JOIN `dim_seat` USING (id_dim_seat)
WHERE id_fmr = 3
GROUP BY id_fmr;