CODEWITHSUNDEEP
mysqlsql
siva sandeep garapati
siva sandeep garapati

Reputation: 43

sql query error while using joins with where an in operators

These are my tables

enter image description here

enter image description here

I am trying to write a query where i can give a date to search weather the date between start and end dates in events table or specific_date in specific dates table and retrieve records from events

eg :

select * from events left join specificdates on events.event_id=specificdates.event_id WHERE ('2017-01-29' BETWEEN events.start_date AND events.end_date) OR  ('2017-01-29' IN 
    specificdates.spefific_date)

Upvotes: 0

Views: 36

Answers (1)

krishn Patel
krishn Patel

Reputation: 2599

try this one 

 select * from events left join specificdates on events.event_id=specificdates.event_id
 WHERE ('2017-01-29' BETWEEN 
 events.start_date AND events.end_date) OR  (specificdates.spefific_date IN ('2017-01-29'))

Upvotes: 1

Related Questions