SQL. How to request data between two dates in such a case?

Question

SQL

Good afternoon.
There is a query with LEFT OUTER JOIN

SELECT u.event_id, u.event_name, u.start_date, u.end_date, u.serv_id, d.name, c.client_nm as cli FROM tevents u LEFT OUTER JOIN doctors d ON u.`type` = d.id LEFT OUTER JOIN clients c ON u.`combo_select` = c.id

How else can I insert a selection by date range here? ..

WHERE u.start_date between "2018-05-23 08:50:00" and "2018-05-23 08:50:00"

thanks in advance

Answer 1

So you have a tevents table with an alias u always returned in full, so just add your condition code to the query, it doesn’t matter which join is left or inner in this case.

SELECT u.event_id, 
       u.event_name, 
       u.start_date,
       u.end_date,
       u.serv_id, 
       d.name, 
       c.client_nm as cli 
  FROM tevents u 
  LEFT OUTER JOIN doctors d 
    ON d.id = u.type
  LEFT OUTER JOIN clients c 
    ON c.id =  u.combo_select
 WHERE u.start_date between '2018.05.23 06:00:00' and '2018.05.23 21:50:00'

Answer 2

And where is "such a case"?
In your question, the request has already been completely written, glue the second part to the first part.