update inout set danga=(danga*0.5),outpay=(outpay*0.5),dcpay=(dcpay*0.5),pay=(pay*0.5),cashpay=(cashpay*0.5)

where ggubun='등록' and gjong='매출' and cardpay='0'

update inout,inoutgubun set inoutgubun.allpay=(inoutgubun.allpay*0.5),inoutgubun.cashpay=(inoutgubun.cashpay*0.5)

,inoutgubun.cancelpay=(inoutgubun.cancelpay*0.5),inoutgubun.pay=(inoutgubun.pay*0.5)

where inout.calcno = inoutgubun.calcno

and inout.ggubun='등록' and inout.gjong='매출' and inoutgubun.cardpay='0'

날짜 조정은 = and gdate =''

select * from inout

select * from inoutgubun