kenche0820
Programmer
Hello,
I was wondering if it is possible to design a query that can perform an aggregate function on text (compressing records into a comma-delimited list).
I currently have a database with tables for lighting, sound, props, etc. (see
What I'd like to do is have a query that summarizes the lighting cues, sound cues, props, etc. that exist for each scene.
(see Does anyone know if that is possible?
Thanks very much for your time.
Kenneth Cheung
I was wondering if it is possible to design a query that can perform an aggregate function on text (compressing records into a comma-delimited list).
I currently have a database with tables for lighting, sound, props, etc. (see
What I'd like to do is have a query that summarizes the lighting cues, sound cues, props, etc. that exist for each scene.
(see Does anyone know if that is possible?
Thanks very much for your time.
Kenneth Cheung