1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM mst_room_stock AS H_1, mst_rate_daily AS Daily WHERE H_1.stock_date B' at line 5

SELECT Daily.single_use_rate, Daily.twin_use_rate, Daily.triple_use_rate, Daily.four_use_rate,FROM mst_room_stock AS H_1, mst_rate_daily AS Daily WHERE H_1.stock_date BETWEEN '2018-04-23' AND '' AND Daily.plan_cd = 'I-00722' AND Daily.room_type_cd = '101' AND Daily.rate_date = H_1.stock_date AND H_1.room_type_cd = Daily.room_type_cdGROUP BY H_1.stock_date;

[TEP STOP]