UPDATE table1 t1, table2 t2, table3 t3 SET t1.date = '2004-03-18' WHERE t1.id_2 = t1.id_2 AND t3.id_1 = t2.id_1
On Thu, 18 Mar 2004, Russell Horn wrote: > I haev three tables: > > 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? > > Thanks, > > Russell. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]