delete from fnb_eos where f_closedate < '01/01/2015' --- delete from pos_audit where aud_closedate < '01/01/2015' --- delete from pos_closeinfo where ci_closedate < '01/01/2015' --- delete from pos_payment where pymt_closedate < '01/01/2015' --- delete from pos_paysumm where pysumm_closedate < '01/01/2015' --- delete from pos_sales where sales_closedate < '01/01/2015' --- delete from pos_salesdtl where sdtl_closedate < '01/01/2015' ---