Re: Need help with a complicate sql select request

Posted in 2006

Thorsten Knopel — Sun, 16 Jul 2006 13:12:37 +0200 — source: Usenet: comp.databases.informix

Thanks all for your help !!! The solution we now use is: SELECT DISTINCT b.usr FROM B b where (SELECT count(*) FROM A a WHERE a.mega_grp = 'mg1') = (SELECT count(*) FROM B c WHERE c.usr = b.usr AND c.man IN (SELECT d.man FROM A d WHERE d.mega_grp = 'mg1' ) ) Thanks again Thorsten