1 Reply Latest reply: Jan 3, 2012 3:05 PM by Jean-Jacques Jesua RSS

    count with no activity



      for simplisty i have 2 tabels orders and customers. linked by field custid.


      order table columns: orderid, custid, orderdate, orderyear, ordernum

      customers table columns: custid, create_date, name



      the needed oupput is



      count orderscount customers

      count customers

      with no order



      the problem is the last column.

      It count all customers  created until the orderyear but doesnt have any order in this year.