I am using version 3.23.54, unfortunately I am unable to supply test
but basically I need to update the Task_ID column for the Bookings table
that it is the same as the Task_ID for Tasks and the Task_Name is
and the Bookings Project_ID is the same as the Tasks Project_ID.
This is what I need to do:
UPDATE Bookings B
SET B.Task_ID = T.Task_ID
WHERE T.Task_Name = 'Booking'
AND B.Project_ID = T.Project_ID
However I dont know how to introduce the Tasks T alias into the query!
Fortunately we have been having a discussion about multi-table updates
for the past couple of days. Unfortunately your version of MySQL does
not support multi-table updates (http://www.mysql.com/update - "Starting
with MySQL 4.0.4, you can also perform UPDATE operations that cover
"It causes you to go to the end so that you can read from the
"Top posting is bad"