Re: counting multiple items

[Peter Brawley]

Is this what you mean?

select n2997, n1043, n882, n2997+n1043+n882 as sum
from { 
  select 
    sum( if(r.srvno=2997,1,0) )  as n2997,
    sum( if(r.srvno=1043,1,0) )  as n1043,
    sum( if(r.srvno=882, 1,0) )  as n882
  from patient p
  join records r using(patno)
  where r.ssdo=true and r.patno=18025; 
) sums

Edited 2 time(s). Last edit at 12/06/2018 04:04PM by Peter Brawley.