Good morning to all!!!
I need to know why this code generates an error? It is my understanding that I can create a table "Test" with 3 fields...
Create Table Test(
Title_ID VarChar(6) Null,
Title VarChar(80) Null,
Type Char(12) Null)
.. and populate it using a select statment filling only 2 fields...
Insert into Test
Select
title_id,
title
from titles
... but this script keep generating an error:
"Insert Error: Column name or number of supplied values does not match table definition."
I know that this error occurs if i supply more fields in the INSERT statement than what is available in the TABLE. Right?
Dazed & confused
Martin
Shit happens!!!