Query error

I have a process that updates table ITEMS with a NAME_CATEGORY and I need to
later find the corresponding index for it and insert it.

This query fails out and does not like the test.ITEMS.NAME_CATEGORY

INSERT into test.ITEMS (ID_CATEGORY)
select ID from test.CATEGORY where test.category.NAME =
test.ITEMS.NAME_CATEGORY

Any ideas?
Thanks!!!
Mica


-----sample tables
TABLE Category
-ID
-NAME

TABLE ITEMS
-ID
-ID_CATEGORY
-NAME_CATEGORY