"Williams, Ken" <[EMAIL PROTECTED]> writes:
> Hmm, I'm not sure whether I can use that in this context. My actual desired
> query is:
>
> sqlite> UPDATE output, tokens
> ...> SET output.stop=output.stop+1
> ...> WHERE output.sentence=tokens.sentence
> ...> AND output.stop=tokens.position
> ...> AND output.type='prop'
> ...> AND tokens.postag='RP';
Maybe something along the lines of this could work. There's probably a more
elegant method than this:
UPDATE output
SET stop=stop+1
WHERE ROWID =
(SELECT output.ROWID
FROM output, tokens,
WHERE output.sentence=tokens.sentence
AND output.stop=tokens.position
AND output.type='prop'
AND tokens.postag='RP');
Derrell
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
