Another way you could do it is: SELECT h.History_ID, h.LastName, h.FirstName FROM History h INNER JOIN Operator o ON h.Device_ID = #Client.wDevice_ID# WHERE o.Operator_ID = h.Operator_ID_Out AND h.History_ID > #Client.wLastHistory_ID#
Not really sure which is faster, but I tend to see Joins used more then commas (commas being a full outer join anyways) _____________________________ steve oliver senior internet developer atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:48 PM To: CF-Talk Subject: QUERY Differences? 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 ______________________________________________________________________ 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=coldfusiona 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
