Sorry, should have been:
INSERT +
INTO problemtables +
SELECT tablename, newcount ,oldcount,.#DATE,.#TIME, .vdbold +
FROM tablecompare +
WHERE oldcount <> newcount OR newcount IS NULL
On 19 Jun 2003, at 16:22, Jim Limburg wrote:
> Ben
>
> This gives me an error of Invalid Syntax..
> INSERT +
> INTO problemtables tablename, newcount ,oldcount,.#DATE,.#TIME, .vdbold +
> FROM tablecompare WHERE oldcount <> newcount OR newcount IS NULL
>
> Jim limburg
>
> Ben Petersen wrote:
> > INSERT INTO problemtables Col1, Col2, Col3, .#DATE,.#TIME, .vdbold +
> > FROM tablecompare +
> > WHERE oldcount <> newcount OR newcount IS NULL
> >
> >
> > On 19 Jun 2003, at 16:00, Jim Limburg wrote:
> >
> >
> >>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
> >>
> >
> >
> >
>
