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
Select *Quote:
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
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