A Simple SQL Update Via PHP

[NFD]

Hi,

What I am trying to do is update one field on one table based upon a match of anoother field on another table.

Here is my initial query (at this stage entered via phpmyadmin):
UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `group` = 'table2.group' ;

Whilst the query itself runs, it affects 0 rows which is unexpected as there are 2000+ matches.

Firstly I need to know what part of the query am I doing incorrectly?

Afterwards, I want to have a go at making it a query run as part of a php file that does alot of data inserts first.

Any help that can be given would be much appreciated :)

[pendelton]

Have you tried using phpmyadmin to see what is going on?

[corbin]

UPDATE `table1` SET `test_id` = 'table2.test_id' WHERE `table1.group` = 'table2.group';

I doubt thats it, but worth a try :P.

[Barand]

I think it's
[code]
UPDATE `table1`, `table2`
SET `table1`.`test_id` = `table2`.`test_id`
WHERE `table1`.`group` = `table2`.`group`;
[/code]
BTW, "group" isn't a good choice of column name as it's a MySQL reserved word