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

