Bill,

I have to include VENDNO otherwise the next join fails.

INNER JOIN apvend01 v;
ON S.vendno = V.vendno;



Jeff