On Sat, Sep 17, 2005 at 03:23:04PM +0200, Miha Vrhovnik wrote: > > both > SELECT DISTINCT id, * FROM t1, map WHERE t1.id = map.idT1; > and > SELECT * FROM t1, map WHERE t1.id = map.idT1 AND id IN (SELECT DISTINCT idT1 > AS id FROM map WHERE d0 = 2);
sqlite> SELECT id, * FROM t1, map WHERE t1.id = map.idT1 GROUP BY id; 1|1|1|dddddd|1|2 2|2|1|dddddd|2|2 3|3|1|dddddd|3|2 Not sure if this is really what you want, because you're losing data from the map as rows are excluded. -- Matt Wilson rpath, Inc. [EMAIL PROTECTED]