Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at RIA Unleashed (Nov. 2010) with: Chris Bickford
Ben Nadel at RIA Unleashed (Nov. 2010) with: Chris Bickford ( @chris_bickford )

supriya

Member since Mar 23, 2012

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 »