> You cannot do this with a join, however, you CAN do this
> with a selectable stored procedure - make it an inline select
> and let the procedure select the flags and concat them into
> the output string.

Thanks Martijn

OK. I could cache the PEOPLE_FLAGS and just get the SP to concat
their PK's which would result in less data being sent down the wire.

I guess that means for 'n' entries in my people table, I'm doing 1+'n'
selects. I'm using FB embedded for this application and I expect the
majority of the machines will be fairly weedy, hence my need to keep
the SQL processing down to a minimum.

David