Well,

> > 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.

If you're using "embedded": what 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.

I doubt there's any difference between returning the actual string
compared to returns "14, 1, 15" etc...

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com