Complex query

From: Bruno René Santos (brunoren..olos.pt)
Date: Thu Oct 28 2010 - 13:23:22 UTC

  • Next message: Michael Gentry: "Re: MySQL error - connection reset"

    Hello all,

     

    How can I perform a query in cayenne such as this:

     

    SELECT A, B, C

     

    FROM (

     

    (SELECT

         SUM( table1.A) A,

         SUM( table1.B) B,

          table2.C C

     FROM

         Table1

          INNER JOIN table2 ON table1.fk = table2.id

     

    WHERE ...

     

     

    Where you do not have a rootClass to start with?

     

    Thanx

    Bruno

      

    -- 

    Bruno René Santos | Gestor de Projectos - Project Manager |
<mailto:brunoren..olos.pt> brunorene@holos.pt |  <http://www.holos.pt>
http://www.holos.pt

     

    Holos - Soluções Avançadas em Tecnologias de Informação S.A. 

    Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan Parque 

    Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica 

    Phone: +351 210 438 686 . Fax: +351 210 438 687 

     

    This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you are not the intended recipient or the person responsible for delivering the
email to the intended recipient, be advised that you have received this email in
error and that any use, dissemination, forwarding, printing, or copying of this
email is strictly prohibited. If you have received this email in error please
notify Bruno René Santos by telephone on +351 210 438 686

    This archive was generated by hypermail 2.0.0 : Thu Oct 28 2010 - 13:23:56 UTC