I am trying to read value from a table them insert it into another table only if the staring that I am trying to insert does not already exist in the table.

I have tried to use the ON DUPLICATE KEY clause but I get a syntax issue that i am unable to fix.

this is my query

```
SELECT Field1 FROM RSF
INSERT INTO result_codes(result_code_title, created_by)
VALUES (Field1, '2')
ON DUPLICATE KEY UPDATE result_code_title = Field1;

```