1 Reply Latest reply on Mar 24, 2006 7:33 AM by Martin Heinemann

    subquery in from clause

    Ralf Alt Newbie

      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