SELECT Orders.o_orderno, Products.p_productname, Orders.o_orddte,; Orders.o_ordcomp, Orders.o_qty, Orders.o_unitprice, Orders.o_orderedby,; Products.p_warehouseno, Vendors.v_name, Orders.o_checkmark,; Orders.o_v_vendorid, Orders.o_p_productid, Orders.o_orderid,; Orders.o_w_whsid, Whsupv.whs_name, Orders.o_tmp_amt, Orders.o_tmp_qtyrec,; Orders.o_tmp_daterec, SUM(Recdetail.rd_qtyrec); FROM ; warehouse!orders ; INNER JOIN warehouse!products ; ON Orders.o_p_productid = Products.p_productid ; LEFT OUTER JOIN warehouse!recdetail ; ON Orders.o_orderid = Recdetail.rd_o_orderid ; LEFT OUTER JOIN warehouse!whsupv ; ON Orders.o_w_whsid = Whsupv.whs_id ; LEFT OUTER JOIN warehouse!vendors ; ON Orders.o_v_vendorid = Vendors.v_id; WHERE Orders.o_orddte >= ( ?lc_bdate ); AND Orders.o_orddte <= ( ?lc_edate ); ORDER BY Orders.o_orddteWhen I go to save I get and error saying "SQL: GROUP BY clause is missing or invalid"