At 04:05 PM 10/4/2004, [EMAIL PROTECTED] wrote:
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
Thanks for the quick response. It's somewhat gratifying to hear that I'm
not alone in my confusion...
Ted
--
I guess the docs aren't totally clear on this as you are not the first
person to have problems forming a multiple-table UPDATE statement.
http://dev.mysql.com/doc/mysql/en/UPDATE.html
UPDATE dp_populate_vals
INNER JOIN dp_populate_tables
ON dp_populate_tables.tgt_tbl=dp_populate_
> I'm trying to update existing records in one table so that value of a
> column winds up matching the value of a column in a second table, based on
> a match in a second column in each table.
>
> I'm not sure if I'm taking the wrong approach on this, of if I'm missing
> something simple in the SQL
Greetings,
I'm trying to update existing records in one table so that value of a
column winds up matching the value of a column in a second table, based on
a match in a second column in each table.
I'm not sure if I'm taking the wrong approach on this, of if I'm missing
something simple in the