[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
<[EMAIL PROTECTED]>
To: "shaun thornburgh" <[EMAIL PROTECTED]>,
Subject: RE: Help with an UPDATE query please
Date: Wed, 29 Dec 2004 13:53:07 -0600
[snip]
I am having trouble with an UPDATE query. I have three tables as defined
below. My database holds data for bookings. Each booki
[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 t
Hi,
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