SELECT u.var_emailid,r.int_glcode as int_glcode,CONCAT(u.var_fname,' ',u.var_lname) as name, r.dt_reservationdate as date,rt.tm_starttime as time from bc_reservation_mst r inner join bc_users u on u.int_glcode=r.fk_users_mst inner join bc_reservationtime_mst rt on rt.int_glcode=r.fk_reservationtime_mst where r.dt_reservationdate=CURDATE()+1 and rt.tm_starttime>CURRENT_TIME and r.chr_reminder_mail!='Y' and r.chr_delete='N' and r.chr_status='A'