>Hi All:
>
>I'm having trouble getting the desired results for an SQL statement.
>
>I have 2 tables. FEEDINV has a bunch of records of invoices, each with a delivery date. For each record in FEEDINV, I want a matching record in RATPRIC, where the date in RATPRIC is equal to or less than, BUT I only want the CLOSEST record in RATPRIC AND only if is within 7 days. (Kind of like SET NEAR ON, SEEK). ALSO, I only want a match if FEEDINV.fi_cpprim = RATPRIC.rp_cpprim.

Yossi - take a look at the code I wrote for you for the INGRPT. It does the same sort of thing you're looking for.

Tamar