Posted by jc-Atl on 10/14/42 11:28

Thanks! That did it! I was leaving out the "recruiterDB_candidates" in the
UPDATE part of the statement.
But why do I have to include it, since I was only updating
recruiterDB_extraNotes ?

Thanks !

"Hilarion" <hilarion@SPAM.op.SMIECI.pl> wrote in message
news:dhrosd$rqe$1@news.onet.pl...
> > 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

[Back to original message]