Re: SQL Update Script.... please help!

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 14 Nov 2000 17:17:56 GMT
Message-ID: <8urs3r$9ra$1@nnrp1.deja.com>

In article <974217737.27449.0.nnrp-09.c2d92da9_at_news.demon.co.uk>, "Darren Lambert" <darrenlambert_at_hotmail.com> wrote:
> 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
>
> ----------------------------------------------
>

Oracle update statement would look somewhat different: Update CustomerOrdersH set (CustomerOrdersH.Deliveryjourneyid, CustomerOrdersH.DeliveryVanNo, CustomerOrdersH.DeliveryRouteID, CustomerOrdersH.DeliverySalesmanPIN) = (select Journeys.journeyid, Journeys.VanNo, Journeys.RouteID, Journeys.SalesmanPIN from Jorneys Where Journeys.JourneyID = 1210000101)

BTW, it'll update all records in CustomerOrdersH. Is it what you want?
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 14 2000 - 11:17:56 CST