SELECT sm.date, cm.cust_name, cim.city_name FROM
schd_detail AS sd INNER JOIN schd_mst AS sm ON sm.sch_id=sd.sch_id
INNER JOIN cust_mst AS cm ON sd.cust_id =cm.cust_id
INNER JOIN city_mst AS cim ON cm.city_id=cim.city_id where sm.date='2013-11-01'
UNION
SELECT tm.date, cm.cust_name, cim.city_name FROM
tour_mst AS tm INNER JOIN cust_mst AS cm ON tm.cust_id =cm.cust_id
INNER JOIN city_mst AS cim ON cm.city_id=cim.city_id where tm.date='2013-11-01'