updating one table with another's values

[jesus_hairdo]

i have 2 tables in my database (called testing)
one called info, another called temp.
Basically the temp table holds values that the info table will be updated with.
What i want to do is rather than having 1 sql statement to retrieve the values from temp, and construct another sql statement from that. Is to do it all in 1 sql, i'm trying to do this,

"update testing.info
set testing.info.name = testing.temp.name,
testing.info.age = testing.temp.age
where testing.temp.id = $id
and testing.info.id = testing.temp.info_id ;"

whenever i try to run this be it through the browser or from a mysql prompt, i get unknown table 'testing.temp' in field list. any ideas why ?
(BTW it can see the temp table easily, i can do a select * from temp fine.)

cheers

Jamie

[amcgrath]

Just outta curiousity, mostly cuz I'm at a loss, have u tried it without the testing. database reference?

[jesus_hairdo]

yeah, that didn't work either, just said , table temp not found

[amcgrath]

Wow, you got me. Are you sure your connecting to the right database? (Grasping at straws, cuz it all looks right).

[jesus_hairdo]

yeah, i've even tried from a mysql promtp.
i can do a select * from temp and it returns all of the records, i then on the very next line tried the update and it failed