Board index » delphi » Left outer join

Left outer join


2003-12-04 08:22:39 AM
delphi91
Any differences of the followings:
SELECT *
FROM Customer c
LEFT JOIN Orders o ON o.customerID = c.ID
SELECT *
FROM Customer c
LEFT JOIN Orders o ON c.ID = o.CustomerID
 
 

Re:Left outer join

Alan writes:
Quote
Any differences of the followings:

SELECT *
FROM Customer c
LEFT JOIN Orders o ON o.customerID = c.ID


SELECT *
FROM Customer c
LEFT JOIN Orders o ON c.ID = o.CustomerID



In SQL Server 2000 have QueryAnalyzer show the ExecutionPlan for both.
You will see that the execution plan is exactly the same.
You should also get the same result set.
So technically the answer is, no.
For readability I much prefer the first option.
Ross