Re: [sqlite] update inner join syntax

[Roger Miskowicz]

Thanks Richard, it worked perfectly.
 Roger

[EMAIL PROTECTED] wrote:

UPDATE stocks SET bOption=1 WHERE rowid IN
  (SELECT stocks.rowid FROM Stocks, Options
    WHERE Stocks.sStockSymbol = Options.sStockSymbol);

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------