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