>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.
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 =
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://lis
