Lynn Pettis (8/22/2014)
mario17 (8/22/2014)
you actually got Q#4.:-)But I understand what my query is doing easier than Chris's Q4. The parens make the order of the joins visually apparent. The other way just isn't intuitive for me.
That's a pretty common feeling about that syntax. I just hate parens. When I do code that way I usually put in a comment along the lines of:
/* The order of the ON's enforces a the order of the JOIN's */
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question