Skip to main content
Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.


Member since Aug 30, 2014

Recent Blog Comments By Erwin

  • The Anatomy Of An INNER JOIN Query In SQL

    Posted on Aug 30, 2014 at 10:17 AM

    Despite violating the semantics, as outlined by Roland, I think you can argue in Ben's example above, that in the query you'd want to join the primary billing_information which is identified by the billing_information table with isPrimary=1. If I think of it like that, then it makes more sense to me... read more »

  • Grouping JOIN Clauses In SQL

    Posted on Aug 30, 2014 at 7:30 AM

    Yes, excellent! I've always been using the derived table alternative for years, but this is clearly more elegant.... read more »