CODEWITHSUNDEEP
mysqlsql
Doug Millett
Doug Millett

Reputation: 1

What's wrong with my date range in this SQL statement?

I'm attempting to select data in a date range, but this is not working:

SELECT form_user.email
FROM form_instance JOIN
     form_user
     ON form_instance.form_user_id = form_user.form_user_id
WHERE form_instance.appointment_date >= '2017-04-13' AND <= '2017-05-11' AND
      form_instance.status = 3

Upvotes: 0

Views: 24

Answers (1)

RoMEoMusTDiE
RoMEoMusTDiE

Reputation: 4824

this is the issue

 form_instance.appointment_date >= '2017-04-13' AND <= '2017-05-11'

this should be

 form_instance.appointment_date >= '2017-04-13' AND   form_instance.appointment_date <= '2017-05-11'

or use BETWEEN

Upvotes: 3

Related Questions