> When I run the following
>
> update dockets set LogPrice = (select LogPrice from Temp
> where temp.docketno = dockets.docketno)
UPDATE Dockets
SET LogPrice = ( SELECT LogPrice FROM Temp WHERE Temp.DocketNo=Dockets.DocketNo )
WHERE EXISTS ( SELECT 'X' FROM Temp WHERE Temp.DocketNo=Dockets.DocketNo )
The exists should perform considerably better than the IN statement although both will
work.
--
Talden@home
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
