[snip] I am having trouble with an UPDATE query. I have three tables as defined
below. My database holds data for bookings. Each booking relates to a project. Each project has many tasks, one of which is a booking. I have now added the column Task_ID to the bookings table. How can I update all the bookings so that the Task_ID is the same as the Task_ID in the Tasks table for that project and the task is a booking? [/snip] Can you show us some test data and an example of what you want to happen? Also, what version of MySQL are you running? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]