[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]

Reply via email to