Thanks, that works best for me.

[...]

ABS> Use a left join, this will force the table to be fetched before the SP....

ABS> SELECT A.FLD1, A.FLD2, SP.FLD1, SP.FLD2
ABS> FROM TBL1 A
ABS> LEFT JOIN MYSP(A.FLD3) SP ON SP.ID = A.ID


ABS> see you !





Bjoern

--
SOFTbaer --- reimer@... --- www.softbaer.de