in sql 2005, i can use the following subquery in the SELECT clause of my sql query:
,(select table2.usr_id + ',' from table2 where table2.table_id = table1.table_id for xml path('')) as techname
if there are multiple usr_id 's in table2, they are returned as one field, with commas between each value.
what is the Informix equivalent?
p.s. multiset seems to be reserved for db owner, and i don't have owner permissions.