MySQL Forums
Forum List  »  Newbie

counting multiple items
Posted by: Jim Sawyer
Date: December 06, 2018 03:31PM

I would like to modify the following query:

From Patient
select count(*) as count
join records on records.patno = patient.patno
where records.servno = 2997
and records.ssdo = true
and records.patno = 18025;

How could I modify that query such that instead
of counting just records.Servno = 2997, it woud
count records.servno = 2997 and records.servno = 1043
and records.servno = 882?

Jim Sawyer

Options: ReplyQuote

Written By
counting multiple items
December 06, 2018 03:31PM
December 06, 2018 03:33PM
December 06, 2018 03:59PM
December 07, 2018 06:11AM
December 07, 2018 09:31AM
December 07, 2018 12:35PM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.