INNER JOIN

If there is not a matching record in the left or right table then the record will be excluded

SELECT *
FROM SchemaName.LeftTable AS LeftTable 
	-- INNER JOIN  SchemaName.RightTable AS RightTable 
	JOIN  SchemaName.RightTable AS RightTable -- inner join is default
	ON LeftTable.colName = RightTable.colName