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

Reply via email to