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