i need to update the destination table, dt, with values from the source table, st, and join the two on the pk. i get a syntax error with the following :

update dt set c1 = st.c1 from t1 as st, t2 as dt
where dt.pk_id = st.pk_id and dt.last_modified <> st.last_modified

that's sql server syntax that works, i just need help finding the equivalent mysql syntax.

nevermind, i figured it out after finding a mysql reference manual.

update t1 as st, t2 as dt set dt.c1 = st.c1
where dt.pk_id = st.pk_id and dt.last_modified <> st.last_modified