Hi Steve, Thanks.
Does that imply that full outer joins are more expensive than specific inner
joins like in your example?
At 10:06 PM 2/23/02 -0500, you wrote:
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 =
://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 your
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
3 matches
Mail list logo