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