"Gilles Ganault" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > One more thing: I'd like to only retrieve rows where code.number and > COUNT(companies.code) don't match
SELECT code.number, COUNT(companies.code) FROM code JOIN companies ON (code.id=companies.code) GROUP BY (code.id) HAVING code.number != COUNT(companies.code); Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
