Insert a field from a table to another.

[leodrums]

I have to tables with different names, and I need to insert into the destination table a field from the origin table that has the same name as the field in the destination table.

[iburyak]

Insert into destination_table (field1,field2)
Select field1, field2 from origin_table where .....

[leodrums]

Insert into destination_table (field1,field2)
Select field1, field2 from origin_table where .....

Thank's, but still doesn't work. It says "field valuer required". Is there something missing, how would be the complete Syntax.

Thank's a lot.

[iburyak]

You have to give me table definitions and full statement executed so I would be able to help.

[leodrums]

The structure of both tables is exactly the same. And right now i need to copy only one field of the origin table into the destination table. The field format is currency.

Do you need any more information?

Thank's.

[Taftheman]

Try aliases, this might be the cause if the fields from each table are the same

Insert into Table1(Field1, Field2)
Select table2.Field1, table2.Field0
From Table2
Where your code here

[leodrums]

Thank's a lot!!!

That worked.