Complex query with exists

[Edson Carlos Ericksson Richter]

Hi!
I'm using OJB 1.0.1.
I need to perform the following query:
select T.C1 T.C2, sum(U.X1) as total, count(*) as counted
       from tb1 P join tb2 T on P.id = T.id
     where not exists (select * from mTonTable where id = P.id and id2 
= P.id2)
     group by T.C1, T.C2

tb1 and tb2 are XML mapped tables. mTonTable is a implicit M:N mapping 
table.

Thanks for any tips.
--
Edson Carlos Ericksson Richter
MGR Inform�tica Ltda.
Fones: 3347-0446 / 9259-2993

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]