Try separating the 3 items after UNION SELECT: INSERT INTO problemtables SELECT * FROM tablecompare + WHERE oldcount <> newcount OR newcount IS NULL + UNION SELECT (.#DATE), (.#TIME), (.vdbold) FROM dummy
Bill On Thu, 19 Jun 2003 16:00:09 -0400, Jim Limburg wrote: >OK, I don't think I'm far off, but I have a table in want to insert into >values from another table along with some static info.. >Here is the statement I'm using.. > INSERT INTO problemtables SELECT * FROM tablecompare + > WHERE oldcount <> newcount OR newcount IS NULL + > UNION SELECT (.#DATE,.#TIME, .vdbold) FROM dummy >The table is created like this >CREATE TABLE problemtables (tablename TEXT (18), newcount INTEGER,oldcount + > INTEGER, tmstampdt date, tmstamptm time, dbname TEXT (18))
