Skip to main content
Ben Nadel at cf.Objective() 2017 (Washington, D.C.) with: Geoff Bowers
Ben Nadel at cf.Objective() 2017 (Washington, D.C.) with: Geoff Bowers@modius )

Erwin

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 »