>>SET DELETED on >> >>SELECT fi_invnum, fi_flcode, fi_cpprim, fi_weight, fi_dlvdat, rp_rtprim, MAX(rp_date), rp_cpprim ; >>FROM feedinv ; >>left OUTER JOIN ratpric ; >>ON fi_rtprim = rp_rtprim ; >>AND fi_cpprim = rp_cpprim ; >>AND fi_dlvdat > rp_date ; >>AND fi_dlvdat - rp_date < 7 ; >>WHERE fi_flcode = 'BAA12062' ; >>GROUP BY fi_invnum, fi_flcode, fi_cpprim, fi_weight, fi_dlvdat, rp_rtprim, rp_cpprim >>>