RE: SQL table joins: Join vs. Where

Dan,

In SQL the statements:

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

and

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

are exactly the same.  The second one is simply a shorthand form of the
inner join.

HTH,
Charles



> -----Original Message-----
> From: Dan Bale [mailto:dbale@xxxxxxxxxxxxx]
> Sent: Wednesday, August 11, 2004 3:49 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL table joins: Join vs. Where
> 
> Why doesn't RTVQMQRY convert the WRKQRY joins to SQL joins?  
> Is there a
> performance issue between one or the other?
>