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