These two selects BOTH work.
They report very similar execution times.
Is one method preferred? Better? Technically Correct?
------------
SELECT History_ID, LastName, FirstName
FROM History, Operator
WHERE History.Device_ID = #Client.wDevice_ID#
AND Operator_ID = History.Operator_ID_Out
AND History_ID > #Client.wLastHistory_ID#
------------
Select History_ID, LastName, FirstName
FROM History, Operator
WHERE History.Device_ID = #Client.wDevice_ID#
AND Operator_ID = History.Operator_ID_Out
AND History_ID IN
(SELECT History_ID
FROM History
WHERE History.Device_ID = #Client.wDevice_ID#
AND History_ID > #Client.wLastHistory_ID#)
------------
thanks,
Brian
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
