Hallo,
is it possible to have a subquery in the from clause?
The query is
select a.cust.id
from (select distinct o.cust.id, o.art.id
from order o
where o.cust.id = cust.id
and o.date = :_orderdate) a
group by a.cust.id
having count(a) > 3
Thanks
Ralf
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3932351#3932351
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3932351
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user
