Roger Miskowicz <[EMAIL PROTECTED]> wrote:
> I am trying to do an update inner join, and have tried the following
> without success. Would someone please tell me the proper syntax for
> sqlite3?
>
>
> UPDATE Stocks, Stocks -- SQL error: near ",": syntax error
> INNER JOIN Options
> ON Stocks.sStockSymbol = Options.sStockSymbol
> SET Stocks.bOption = 1;
>
> UPDATE Stocks
> SET bOption = 1
> INNER JOIN Options -- SQL error: near "INNER": syntax error
> ON Stocks.sStockSymbol = Options.sStockSymbol;
>
> UPDATE Stocks
> SET bOption = 1
> FROM Stocks, Options -- SQL error: near "FROM": syntax error
> WHERE Stocks.sStockSymbol = Options.sStockSymbol;
>
> UPDATE Stocks
> SET bOption = 1 -- SQL error: near "FROM": syntax error
> FROM Stocks INNER JOIN Options
> ON Stocks.sStockSymbol = Options.sStockSymbol;
>
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]
-----------------------------------------------------------------------------
