INNER JOIN

This join returns rows when there is at least one match in both thhttp://www.pinaldave.com/bimg/march09ug/inner%20join.jpge tables.

in reference to: SQL SERVER – Introduction to JOINs – Basic of JOINs « Journey to SQL Authority with Pinal Dave (view on Google Sidewiki)