[snip] I am using version 3.23.54, unfortunately I am unable to supply test data but basically I need to update the Task_ID column for the Bookings table so that it is the same as the Task_ID for Tasks and the Task_Name is 'Booking' 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! [/snip] 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 multiple tables:") "It causes you to go to the end so that you can read from the beginning." "Why?" "Top posting is bad" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]