>Table 1 >id_2 | date > >Table 2 >id_1 | id_2 > >Table 3 >id_1 > >I want to set the table1.date = '2004-03-18' for each record in table3. Any >ideas?
Based upon your description you could probably use:
UPDATE table3, table2, table1
SET table1.date = '2004-03-18'
where (table3.id1 = table2.id1) AND (table2.id2 = table1.id2);
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
