"Igor Tandetnik" <[EMAIL PROTECTED]> je ob 17.9.2005 16:20:03 napisal(a):
>Why did you expect the latter? DISTINCT in SELECT DISTINCT detects >identical rows, not identical first columns. The three first rows with >an id of 1 differ in the columns you chose not to show (specifically in >the map.d0 column), that's why all three are returned. > >The second query is equivalent to > >SELECT * FROM t1, map WHERE t1.id = map.idT1 AND id IN (1, 2, 3); > >Of course it returns all rows. > So How can I select DISTINCT ON 1st column OR any other. as sqlite does not support DISTINCT ON (column1, column2, ....) Regards, Miha
