All:

I'm attempting to add one or more records to a FOUR COLUMN table with the
following construct:

INSERT INTO TargetTable +
SELECT BuildingNUM , +
         0 , +
         0 , +
         0  +
  FROM Building +
 WHERE BuildingClassID = 1 +
   AND BuildingNUM NOT IN +
     ( SELECT DISTINCT BuildingNUM +
         FROM SourceTable )

Four columns, Four values. Datatypes all match, unless the zeros (integer)
are interpreted ambiguously. 

What might I be missing here?

Bruce

Reply via email to