You are viewing a plain text version of this content. The canonical link for it is here.

Posted to ojb-user@db.apache.org by Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br> on 2004/12/16 20:20:44 UTC

Complex query with exists

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