7NNS0AD5L7H.txt 739 Bytes
Newer Older
Thitichaipun Wutthisak committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
/*Time*/
select * from tot_mrequest0;
select * from TABSENT_NSTDA;
select * from ttime_history;
select * from ttime_history1;
select * from tleave_summary;
select * from tptime_current;
select * from tptime_current1;
select * from tforgetcard0;
select * from tforgetcard1;
select * from TCHANGESHIFT_NSTDA;

delete tot_mrequest0 ;
delete ttime_current;
delete ttime_current1;
delete TABSENT_NSTDA;
delete ttime_history;
delete ttime_history1;
delete tleave_summary;
delete tptime_current;
delete tptime_current1;
delete tforgetcard0;
delete tforgetcard1;
delete TCHANGESHIFT_NSTDA;


----------------------------------------------------
/*Payroll*/

select * from mempl_amt;
delete  mempl_amt;

select * from mempl_fix;
delete  mempl_fix;