>> >>SELECT Institutions.i_instname, Products.p_productname,; >> Products.p_itemcode, Inst_request.ir_orderby, Inst_request.ir_orddte,; >> Inst_request.ir_instordreq, Institutions.i_instid,; >> Products.p_productid, Inst_request.ir_id,; >> Inst_request.ir_actordaccepted, Inst_request.ir_delivery_type,; >> Products.p_qtyperunit; >> FROM ; >> warehouse!inst_request ; >> INNER JOIN warehouse!products ; >> ON Inst_request.ir_prodid = Products.p_productid ; >> INNER JOIN warehouse!institutions ; >> ON Inst_request.ir_inst_id = Institutions.i_instid; >> WHERE ( Inst_request.ir_orddte BETWEEN ?lc_bdate AND ?lc_edate; >> AND Inst_request.ir_inst_id BETWEEN ?lc_fwid AND ?lc_twid ); >> AND Inst_request.ir_ordercomplete = ( ?lc_ordcomp ); >> ORDER BY Inst_request.ir_orddte >> >>>>