Posted by jc-Atl on 10/03/05 04:41

I'm trying to update the recruiterDB_extraNotes.recruiter_id to set it equal
to the corresponding value in recruiterDB_candidates. But I keep getting
errors when I try this in phpMyAdmin. Can anyone help ?

UPDATE `recruiterDB_extraNotes` SET `recruiterDB_extraNotes`.`recruiter_id`
= `recruiterDB_candidates`.`recruiter_id` WHERE
`recruiterDB_extraNotes`.`candidate_id` =
`recruiterDB_candidates`.`candidate_id`

Thanks !

[Back to original message]