SELECT a.*
   FROM tableA a
   // ...
   WHERE atr_a = 1 AND atr_b = 2

SELECT *
    FROM tableA a
    JOIN tableB b ON a.t_id = b.user_id