[RBASE-L] - RBW65 - Union Select problem

[Jim Limburg]

G-Day

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))
Dummy is by
CREATE TABLE dummy (x TEXT (1))
INSERT INTO dummy x VALUES ('x')
vdbold is populated..

I'm figuring the select fills the first three columns, and the union fills
the rest, but I keep getting the error 2148 - Expression contains extra comma
What am I doing wrong here?
Jim Limburg