Append query

[npa3000]

Hello,

I have 2 tables where from one I want to transfer a column to the other based on an ID.

Specifically I have the PRODUCTS table with the fields PRODUCT_ID and TRANSLATION.
I also have the TEST table with ID and trans fields.

So I want to transfer all the trans fields from TEST to TRANSLATION of PRODUCTS based on ID.

I have created the query below but it doesn't work.

INSERT INTO PRODUCTS ( TRANSLATION )
SELECT test.trans
FROM test
WHERE (((test.ID)=[PRODUCTS].[PRODUCT_ID]));

Do you have any idea?