Colby Jensen asked 2 years ago
Here I am not getting back any results and am wondering where the error is in my lines. This is what I wrote.
SELECT creditdescription, COUNT(encid) AS encounter_count
FROM creditrating
INNER JOIN customer ON creditrating.creditid = customer.creditid
INNER JOIN encounter ON customer.customerid = encounter.customerid
WHERE encdate IN (2015-07-05,2015-07-12,2015-07-19,2015-07-26)
ORDER BY creditdescription DESC
Am I counting the wrong thing?
I used = signs. Something like this:
WHERE encdate = ‘2015-07-05’
OR encdate = ‘2015-07-12’
OR encdate = ‘2015-07-19’
OR encdate = ‘2015-07-26’
GROUP BY creditdescription
ORDER BY creditdescription
It pulled it up for me (I hope). Maybe I need parenthesis around the part with the dates?