How to SELECT Multiple Tables using INNER JOIN Statement with Transact SQL (T-SQL) SQL SERVER #11 

Using INNER JOIN
Of the three most commonly used JOIN operators, INNER JOIN is the one that you will likely use on a
regular basis. INNER JOIN is an equality match between two or more tables. For example, assume you
have a table that contains products and another that contains sales, and you want to find only the
products that have been sold.
Regardless of whether you are writing an INNER join or an OUTER join, you start with a basic SELECT
statement