Ah, well then: UPDATE BookingOptions SET IsConfirmed = 1 WHERE BO_ID IN (SELECT BO_ID FROM Bookings WHERE BO_BookingDate != NULL)
On 7/31/06, Andrew Scott <[EMAIL PROTECTED]> wrote: > Sorry, > > This is msSQL 2000 and it is saying syntax error near ')' > > I had to create a mapping table, and this table needs to now be populated > with a IsConfirmed = 1 when the BO_BookingDate is not NULl in Bookings and > the link is BO_ID in both tables, which I ommited from the query I posted. > > I know I got this to work once before, and I wrote it the way I would have > thought I did it last time and to no avail, I knew I should have kept the > query some where:-) > > I am stuck getting this to work again:-) -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2537 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
