> >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 > >>