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:[email protected]> [email protected] | <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
