September 18, 2010 at 6:17 am
Hi all,
I know WHAT inner joins are, but I just wanted to get refreshed on their use with 3+ table joins, along with the most commonly used statements/clauses, ie Datediff's, Cast's etc.
The purpose is to be able to read a statement and have a good idea at a glance what info it pulls from what tables and how (if at all) it converts it.
Thanks,
Jim
September 18, 2010 at 10:42 am
That's a rather broad topic and probably beyond the scope of this forum unless you have a more specific question. You're better off searching for T-SQL tutorials.
I will say that the characteristics of INNER JOINS don't change as you add more tables. OUTER JOINS do have an extra concern you don't see with INNER JOINS in that order MAY be important and you may need to take steps to ensure a particular order. Other than that JOINS are JOINS. If you understand two table JOINS you understand three+ table JOINS.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply