MySQL query question...

[IceOnFire]

I am having trouble writing a query that Select/Joins two tables and updates
a certain rows in table 2 that meet certain criteria in table 1. Should I
use a nested query? Any Suggestions?

[Siemel Naran]

"IceOnFire" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

I am having trouble writing a query that Select/Joins two tables and updates a certain rows in table 2 that meet certain criteria in table 1. Should I
use a nested query? Any Suggestions?

According to the docs, MySql has an extension to let you update one more
tables at once while selecting from more tables.

update Table1, Table2
set Table2.the_column = 20
where Table2.table1_id = Table1.id and Table1.the_other_column = 30

[Siemel Naran]

"IceOnFire" <[e-mail]> wrote in message
news:10*************@corp.supernews.com...

I am having trouble writing a query that Select/Joins two tables and updates a certain rows in table 2 that meet certain criteria in table 1. Should I
use a nested query? Any Suggestions?

According to the docs, MySql has an extension to let you update one more
tables at once while selecting from more tables.

update Table1, Table2
set Table2.the_column = 20
where Table2.table1_id = Table1.id and Table1.the_other_column = 30