SQL Project Quer #10

Questions ArchiveCategory: QuestionsSQL Project Quer #10
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?

1 Answers
Justis answered 2 years ago

use ORs instead of IN, for some reason it doesn’t work with date data types

Your Answer

0 + 3 =