RE: QUERY Differences?

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

RE: QUERY Differences?

2002-02-24 Thread Steve Oliver
://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

RE: QUERY Differences?

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