Помогите с запросом

[AndyD]

А зачем так сложно?

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