On 11/24/2018 7:44 PM, Bart Smissaert wrote:
The very much simplified example works fine, but my real SQL is a bit more
complex:
select gp_name, count(*) as pat_count,
sum(emis_number in(select emis_number from diabetics)) as diab_count from
patients
where emis_number in(select emis_number from diabetics)
and emis_number in(select emis_number from on_non_insulin)
or emis_number in(select emis_number from on_insulin)
group by gp_name
order by pat_count asc
Just in case you are not aware, AND has higher precedence than OR. Your query
does ( (Diabetics AND Non-Insulin) OR Insulin ) as opposed to ( Diabetics AND
(Non-Insulin OR Insulin) ). Apologies if you knew that and really meant the
former.
The above SQL works, but gives too low counts for diab_count .
Show sample data, the result you expect, and the result you observe instead.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
