Hi 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
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