Here is your Query
SELECT COUNT(T1.Column1) FROM @Table1 T1 INNER JOIN @Table2 T2 ON ( (T1.column1=T2.Column1) AND T1.column2=1)
I have tested this with below sample data
DECLARE @Table1 AS Table(Column1 INT,Column2 INT)
DECLARE @Table2 AS Table(Column1 INT)
INSERT INTO @Table1
SELECT 1,1
UNION
SELECT 3,1
UNION
SELECT 2,2
INSERT INTO @Table2
SELECT 1
UNION
SELECT 2
SELECT COUNT(T1.Column1) FROM @Table1 T1 INNER JOIN @Table2 T2 ON ( (T1.column1=T2.Column1) AND T1.column2=1)
Result of this query according to sample data considered in this example
Count = 1
Hope this helps, If yes then accept and vote the answer