Hi you guys, Jayesh, I agree and have found it often the case that the INNER JOIN clause is much slower than the where clause. In this case, it didn't help, however.

Thanks

>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
>>>>