> INSERT INTO problemtables SELECT * FROM > tablecompare + > WHERE oldcount <> newcount OR newcount IS NULL + > UNION SELECT (.#DATE,.#TIME, .vdbold) FROM dummy
I think what you want is: INSERT INTO ProblemTables SELECT *, (.#Date), (.#Time), .(vdbold) FROM TableCompare WHERE OldCount <> NewCount OR NewCount IS NULL No UNION necessary. -- Larry __________________________________ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com
