Roger Miskowicz wrote:
I am having a problem updating a table in one of two attached
databases. What I want to do is indicate in one table whether a name is
listed in a table in the other attached database. I am sure it is
simple but I can't get the UPDATE criteria to work properly.
Any help would be appreciated.
Thanks,
Roger
/* Test ATTACH two Databases SOC and Options and set one column in a
Table in SOC*/
DETACH Opt;
DETACH SOC;
ATTACH 'SOC.db' AS SOC;
ATTACH 'Options.db' AS Opt;
UPDATE Stocks SET bOption = 0;
SELECT DISTINCT Stocks.sStockSymbol, bOption FROM Stocks INNER JOIN
Options ON Stocks.sStockSymbol=Options.sStockSymbol ORDER BY
Stocks.sStockSymbol;
Where are the names Stocks and Options coming from? Should the ATTACH
statements use "AS Stocks" and "AS Options" ?
Gerry
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------