mysql - Left join with where condition and use betwen operator two date column -

i want left join 2 table access_event_logs , hrm_personal_information works perfectly.

 query is:         select concat(first_name," ",middle_name," ",last_name) name,          h.timestamps,          a.pbi_id                   access_event_logs h left join hrm_personal_information on h.userid=a.pbi_id          1 group date(h.timestamps); 

but use condition between operator left join not work .

   query is:     select concat(first_name," ",middle_name," ",last_name) name,      h.timestamps,      a.pbi_id           access_event_logs h left join hrm_personal_information on h.userid=a.pbi_id      h.userid=100032 ,     h.timestamps between '2015-11-02' , '2016-11-20'      group date(h.timestamps); 

how can solve it? please me.

as timestamp either need convert timestamp field date or add time in comparison

like

date(h.timestamps) between '2015-11-02' , '2016-11-20' 

or

h.timestamps between '2015-11-02 00:00:01' , '2016-11-20 23:59:59'