SQL. How to combine two queries in this case?

Question

MySQL

Good afternoon.
There are 2 tables doctors and testt.
And I need to execute 2 requests. First in table testt by date:

SELECT * FROM testt WHERE '2018-05-13' BETWEEN date_in AND date_out

And then from two tables:

SELECT * FROM doctors, testt WHERE testt.sec = doctors.id

How would you put it all in one request? thanks in advance

Answer 1

Learn SQL: join

SELECT 
testt.*, 
doctors.* 
FROM testt 
LEFT JOIN doctors 
ON testt.sec = doctors.id 
WHERE '2018-05-13' BETWEEN date_in AND date_out

Answer 2

join