Jayesh,
I really didn't know it might differ in speed. Thanks for the info.
Cetin
>Yes, It is an inner join but I don't want to use INNER JOIN clause in the query.
>
>Speed of the following two queries may differ.
>
>1. SELECT Tran.cmastid,Mast.cname
> FROM Tran,Mast
> WHERE Tran.cmastid = Mast.cid
>
>2. SELECT Tran.cmastid,Mast.cname
> FROM Tran INNER JOIN Mast
> ON Tran.cmastid = Mast.cid
>
>Hope this will clear your thoughts.
>
>Bye
>Jayesh
>
>
>
>
>>Jayesh,
>>Isn't that an inner join ?
>>Cetin
>>>I didn't tell her to use INNER JOIN, just use '=' instead. and It can make a difference.
>>>
>>>Bye
>>>Jayesh
>>>