Hello all, I have a question about doing an update statment that involves 2 tables; a Key table and the table that is to recieve the key update. Basically I have the duty to update an old key to a new key. All the keys are unique and mapped (eg: oldkey and newkey are the fields) and all i have to do is update the main table. currently i am having issues coming up with the working syntax so i am here looking for your help. here is what i have so far: update maintable set maintable.legacyid = (select newID from keytable where maintable.legacyid = keytable.legacyid) where keytable.legacyid is not null this is the last incantation of my attempt. thank you in advance!