supriya
Member since Mar 23, 2012
- Profile: /members/9761-supriya.htm
- Comments: 1
Recent Blog Comments By supriya
-
SQL Optimization And ON Clause vs WHERE Clause
Posted on Mar 23, 2012 at 6:38 AM
can u please tell me the difference between this 2 stmt. 1.SELECT o.* FROM Customer c LEFT JOIN [Order] o ON o.CustomerID = c.CustomerID AND o.OrderType = 'Cash' WHERE c.Country = 'USA' 2.SELECT o.* FROM Customer c LEFT JOIN [Order] o ON o.CustomerID = c.CustomerID WH... read more »