RE: [sqlite] Update using multiple tables

[Williams, Ken]

Hi Derrell, thanks for the response.

> -----Original Message-----
> From: [EMAIL PROTECTED]
> 
> How about something like this:
> 
> UPDATE table1
>   SET field23 = (SELECT field42
>                    FROM table2
>                    WHERE condition);

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

Can that be transformed into a valid statement using a sub-select as you
suggest?  If I do the obvious thing, the right-sides of the selection
criteria won't be properly "linked" to a single row, right? :

sqlite> UPDATE output
   ...>     SET stop=stop+1
   ...>     WHERE type='prop'
   ...>       AND sentence=(SELECT sentence FROM tokens
   ...>                     WHERE tokens.postag='RP')
   ...>       AND stop=(SELECT position FROM tokens)
   ...>                 WHERE tokens.postag='RP');

 -Ken

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]