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
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#
>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?
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
4 matches
Mail list logo