SELECT a.* FROM TableA a

WHERE

EXISTS 

(SELECT * FROM tableB b WHERE a.Column1 = b.column1 AND a.column2 = b.column2)

or

SELECT a.* FROM TableA a

  INNER JOIN tableB b

    ON a.Column1 = b.column1

    AND a.column2 = b.column2

is this what you meant?