SQL Update Script.... please help!

From: Darren Lambert <darrenlambert_at_hotmail.com>
Date: Tue, 14 Nov 2000 16:02:16 -0000
Message-ID: <974217737.27449.0.nnrp-09.c2d92da9@news.demon.co.uk>

Hello

I'm new to Oracle, but have spent a lot of time with Sybase, SQL Server, etc...

When I try to run the script below I get a ORA-00933 'SQL Command not properly ended'.

Fogive me, but this seems a properly formatted statement to me..

Any help is gratefully received.

Thanks

Darren

Update CustomerOrdersH

Set CustomerOrdersH.Deliveryjourneyid = Journeys.journeyid,

CustomerOrdersH.DeliveryVanNo = Journeys.VanNo,
CustomerOrdersH.DeliveryRouteID = Journeys.RouteID,
CustomerOrdersH.DeliverySalesmanPIN = Journeys.SalesmanPIN

From Journeys

Where Journeys.JourneyID = 1210000101

Received on Tue Nov 14 2000 - 10:02:16 CST