Johnny Withers [mailto:joh...@pixelated.net]
> Sent: Wednesday, September 29, 2010 1:35 PM
> To: Daevid Vincent
> Cc: MySQL
> Subject: Re: How to get hanging 1:M table rows as single
> column in main query?
>
> GROUP_CONCAT() ?
>
> And group by id_fmr ?
>
> JW
>
&g
GROUP_CONCAT() ?
And group by id_fmr ?
JW
On Wed, Sep 29, 2010 at 2:38 PM, Daevid Vincent 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 Seats to