|
-
Jan 16th, 2003, 06:50 AM
#1
Thread Starter
Junior Member
difference between Join Opertaor and its equilvalent where Clause used Query
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|