Thanks for those responses. I'll check them out now. No book suggestions though? Mark Bevan Edwards wrote: > 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
begin:vcard n:Howard;Mark tel;cell:(021) 477 564 tel;fax:(07) 348 8178 tel;work:(07) 348 8177 x-mozilla-html:FALSE adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] fn:Forest Production Systems Ltd end:vcard