RE: SQL table joins: Join vs. Where

[CWilt@xxxxxxxxxxxx]

Do you mean that the following:

select A.A1, B.B1
from A inner join B
   on A.K1 = B.K1

will be faster than

select A.A1, B.B1
from A, B
where A.K1 = B.K1


I'd like to know where you got that information, because as I understand it
that is simply not the case.  Both queries would be run exactly the same
way.

Thanks,
Charles


> -----Original Message-----
> From: Himes, Jay [mailto:jehimes@xxxxxxxxxxx]
> Sent: Wednesday, August 11, 2004 4:40 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: SQL table joins: Join vs. Where
> 
> 
> Also, the a query written using the join systax is usually 
> significatly
> faster than an equivalent query using the where clause.
> 
> Jay Himes
> Liberty University
>