Hi Mark,
This should work:
update dockets
set logprice = (select logprice from temp
where temp.docketno = dockets.docketno)
where docketno in (select docketno from temp)
Regards,
Bevan
> When I run the following
>
> update dockets set LogPrice = (select LogPrice from Temp
> where temp.docketno = dockets.docketno)
>
> all of dockets that are not found in the select statement have
> LogPrice set to Null.
>
> This was NOT my intention. What do I have to do so that only
> those dockets that are found in the select have their LogPrice
> updated - leaving the rest unchanged? This is Paradox.
>
> Anyone recommend a good book for this sort of stuff? - with lots
> of examples. DBD help is very rudimentary.
>
> TIA
>
> Mark
--
Bevan Edwards mailto:[EMAIL PROTECTED]
Achieve Software Limited http://www.achieve.co.nz
Phone: (64-9) 444-4210 ICQ: 732011
Fax: (64-9) 444-4201
Mobile: (64-21) 979-603
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
