Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Matthew Abbott and Andrew Abbott and Chuck Leverette
Ben Nadel at CFUNITED 2009 (Lansdowne, VA) with: Matthew Abbott@abbottmw ) , Andrew Abbott , and Chuck Leverette

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 »