I am having an issue with this SQL Statement i am trying to write. i want to insert the values (Test Facility) from CCID table INTO CCFD table where CCID.id = CCFD.id this is what i have.

UPDATE CCFD.id
SET TEST_FACILITY = (SELECT CCID.id.TEST_FACILITY
FROM CCID.id
WHERE CCID.id = CCFD.id)

or

INSERT INTO CCFD.id
(Test_Facility)
SELECT TEST_FACILITY
FROM CCID.id
WHERE (CCFD.id.INDEX_ID = CCID.id.INDEX_ID)

thanks in advanced

What is the issue you are having??

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

the update statement is giving me an error:
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.

and the insert statement error:

The multi-part identifier "Controlled_Checklist_Facility_Data.FAC_ID" could not be bound.

Ok first about your update statements, basically you can only use a subquery with

SET value = (sub query) if that sub query only returns one value.

And I do not see where you are referencing a Column of FAC_ID in your INSERT statement?

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.