Bjoern Reimer wrote:

>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
>
>

Hi !

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

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


see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br