Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help with a complicate sql select request
from wht i think.. your need is tht it should list all the users
depending on the mega group name you giv..
so i think this should work..
SELECT b.user
FROM b
WHERE b.grp IN
(
SELECT a.grp
FROM a
WHERE a.mega_grp = 'mg1'
);
Received on Sat Jul 08 2006 - 09:39:23 CDT