It seems OK here but I have very limited test data.
SELECT a.vendno, b.item,b.lrecdte,v.company FROM icsupl01 a INNER JOIN (SELECTITEM , MAX(LRECDTE) AS lrecdte FROM icsupl01 GROUPBYitem) b
ON a.item = b.item AND a.lrecdte = b.lrecdte INNER JOIN apvend01 v ON a.vendno = v.vendno
Anyone who does not go overboard- deserves to. Malcolm Forbes, Sr.
