Posted by Hilarion on 10/07/66 11:28

> 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`


What DBMS are you using? MySQL? It should work for MySQL 4.0.4 or newer:

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



Hilarion

• Next in forum: Re: Birthday SQL Problem
• Prev in forum: Re: sorting two result sets by common type field
• Thread view: Re: can anyone help ?

[Reply to this message]