Update a subset of a table based on the content of a temp table.

[Donald Campbell]

I have to update a few records in a table that have been processed. I have the sub-set in a tempprary table. The complication is that the "index" consists of two fields. Not all combinations of the two fields should be updated, only those in the temp table.

In Unify I am used to being able to update comparing the tuple (pair of fields)
e.g.
update enr_invdetail set eid_status = "D" where (eid_enr_no, eid_sem_no) IN (select (tp1_enr_no, tp1_sem_no) from tp1_file) ;

MySQL does not like this saying that you can only have a single field.

Any ideas how I can perform the update?



Edited 1 time(s). Last edit at 02/19/2009 05:38PM by Donald Campbell.