Il Monday 12 November 2007 18:10:40 Osvaldo Rosario Kussama ha scritto: > Try: > SELECT DISTINCT t1.id FROM t1 > WHERE NOT EXISTS (SELECT f1.t FROM f1 > WHERE NOT EXISTS (SELECT x1.t FROM t1 x1 > WHERE f1.t = x1.t > AND t1.id = x1.id)); > > Osvaldo
Nice, it seems to work. But I fear it won't with a longer f1 filter table. Let me think about it. -- Reg me Please ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
