Hi,


I have a Stored Procedure converting some data and want to join with
some other data from a regular select of another table

Is it possible?

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


The message I get is
--
The cursor identified in the update or delete statement is not positioned on a row.
no current record for fetch operation.
--

Update? Delete? There is no Update nor Delete in the SP....





Bjoern

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