SELECT Table1.Id, Table1.Descr FROM Table1 INNER JOIN Table2 ON Table1.Id = Table2.Id WHERE Table2.f = 1 OR Table2.f = 2 OR Table2.f = 3 /*или Table2.f IN (1, 2, 3)*/ GROUP BY Table1.Id, Table1.Descr HAVING COUNT(*) = 3