difference between Join Opertaor and its equilvalent where Clause used Query

[Manni78]

Eg.
Select * from Sales s Join Titles t
On S.titleID = t.TitleID
Join Publishers P
On t.PubId = P.PubId

other Format for the same query


Select * from Sales s,Titles t , Publishers P where s.titleId=t.titleId and t.PubId=P.PubId



Tell me is there any difference between two queries
if yes then which one is efficient Performance wise

[Ecniv]

Select * from Sales s Join Titles t
On S.titleID = t.TitleID
Join Publishers P
On t.PubId = P.PubId

other Format for the same query


Select * from Sales s,Titles t , Publishers P where s.titleId=t.titleId and t.PubId=P.PubId

Select *
From (Sales Titles Left Join Sales On Titles.TitleID=Sales.titleID)
Left Join Publishers On Titles.PubID=Publishers.PubID

Depends what database you are running as to whether the SQL statements would work, and whether you need inner or outer or other types of joins (see top thread for Sql help).

As to performance, well you'd have to try both on 100,000 entries in each table and see. Shouldn't be much difference between them though (IMO).


Vince