Try INSERT INTO TargetTable (TargetColName1,TargetColName2,TargetColName3,TargetColName4) +
SELECT ... Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Saturday, February 28, 2015 7:04 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error Message 118: "Incorrect Number of values for this table" 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
