Advise and suggestions needed

I've got the following questions. I'm creating a db with some tables. In these db I trying to do the following.

Table1 (main):
id customer mon_o_s mon_o_e mon_m_s mon_m_e ....etc.
6 john 09:00 12:00 12:00 18:00
8 doe 10:00 12:00 12:30 17:00

Table2 (close):

id key_db1 closedate_s closedate_e
1 6 2000-05-01 2000-05-01
2 12 2000-05-02 2000-05-02

Table3 (open):

id key_db1 date time_s time_e
1 6 2000-05-08 10:00 17:00
2 13 2000-12-01 10:00 18:00

I want to search when a customer is open:
ex1. John on monday 2000-05-01 10:00 => result closed (see table 2)
ex2. john on monday 2000-05-08 09:30 => result closed (see table 3)
ex3. john on monday 2000-05-08 10:15 => result open (see table 3)
ex4. john on monday 2000-05-15 09:15 => result open (see table 1)
etc.

***Questions:
Can this be done in one SQL statement? If yes, please give me some hints, (I'm banging my head to the walls)
Or is this solvable in PHP, or should I adjust the tables?

All help is appreciated.

-John