cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruno René Santos <brunor...@holos.pt>
Subject Complex query
Date Thu, 28 Oct 2010 13:23:22 GMT
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:brunorene@holos.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

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message