Erwin
Member since Aug 30, 2014
- Profile: /members/12237-erwin.htm
- Comments: 2
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 »