QUERY Differences?

2002-02-23 Thread Brian Scandale
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 His

RE: QUERY Differences?

2002-02-23 Thread Steve Oliver
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#

RE: QUERY Differences?

2002-02-24 Thread Brian Scandale
>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?

RE: QUERY Differences?

2002-02-24 Thread Steve Oliver
http://www.atnetsolutions.com -Original Message- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 24, 2002 6:32 PM To: CF-Talk Subject: RE: QUERY Differences? Hi Steve, Thanks. Does that imply that full outer joins are more expensive than specific inner joins like in