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

Reply via email to