Michael-
> DELETE FROM eiwdb!jobs WHERE nJobID in (select njobid FROM crap)
Generally speaking, this should work just fine. I just wrote the following
test code, and it works as expected in both 8.0 and 7.0. I even changed the
field names to be the same in response to Derek's suggestion.
*-Begin code example
SET DELETED OFF && So you can see it worked
DELETE FILE Snacks.DBF RECYCLE
DELETE FILE Veggies.DBF RECYCLE
CREATE TABLE Snacks (cName C(25))
CREATE TABLE Veggies (cName C(25))
INSERT INTO Veggies VALUES ("Beets")
INSERT INTO Veggies VALUES ("Lima beans")
INSERT INTO Veggies VALUES ("Carrots")
INSERT INTO Veggies VALUES ("Broccoli")
INSERT INTO Veggies VALUES ("Yams")
INSERT INTO Snacks VALUES ("Twinkies")
INSERT INTO Snacks VALUES ("Tapioca")
INSERT INTO Snacks VALUES ("Carrots")
INSERT INTO Snacks VALUES ("Cashews")
CLOSE TABLES ALL
DELETE FROM Snacks WHERE cName IN (SELECT cName FROM Veggies)
USE Snacks
BROWSE
CLOSE TABLES ALL
*-End code example
©2004 Nancy Folsom |
