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