Puneet Kishor <punk.k...@gmail.com> wrote: > is there are way to force the query to return only the "first" match so the > resulting query has only as many rows as the left > table?
SELECT COUNT(*) FROM ( SELECT 1 FROM a LEFT JOIN b ON a.col = b.col GROUP BY a.rowid); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users