sorry to post a new thread but something happened to the other one and i can't reply to it.
On DaPi's advice i used a query like this...
select id,
cast ( multiset( select user_id
from caw_tabsaccess
where caw_tabsaccess.tab_id = caw_tabs.id and caw_tabsaccess.user_id IS NOT null
group by user_id ) as ONEDNUMBERARRAY ) USER_ID
from caw_tabs;
to get multiple rows into one.
the problem is it returns results like this
ID USER_ID
-- -------
1
03-31-2004, 09:23 AM
luciffer
ok i get the same problem in this thread, don't enter anything in angle bracets apparently.