I'm trying to update data on a table with data from another table. I'm using a script that I've used on a SQL DB, but I cannot get it to work on a informix DB. I get a syntax error:

UPDATE table1
SET t1.DATE = t2.date
FROM table1 AS t1
JOIN table2 AS t2
ON t1.ID = t2.ID

table1 may have the same ID more that once, and all IDs need to be populated with the same date value as found in table2 for the same ID.

Any help anyone can provide will be greatly appreciated.

Thanks in advance.