By the way an insert with values does work fine

INSERT INTO Table1 (Field1, Field2, Field3, Field4) values (Table2.Field1, Table2.Field2, Table2.Field3, Table2.Field4)