SQL SERVER – Introduction to JOINs – Basic of JOINs

INNER JOIN

This join returns rows when there is at least one match in both the tables.

SELECT t1.*,t2.*

FROM Table1 t1

INNER JOIN Table2 t2 ON t1.ID = t2.ID