SELECT USER_NO,CUST_NAME,PERSON_TAG FROM EP_CUST_INFO WHERE PERSON_TAG IS NULL 



UPDATE 
  EP_CUST_INFO 
  INNER JOIN K01 
    ON EP_CUST_INFO.USER_NO = K01.USER_NO SET EP_CUST_INFO.PERSON_TAG = K01.PERSON_TAG ;

UPDATE 
  EP_CUST_INFO 
  INNER JOIN K01 
    ON EP_CUST_INFO.USER_NO = K01.USER_NO SET EP_CUST_INFO.CUST_CLASS = K01.CUST_CLASS ;

UPDATE DEP_G_A_EXPENSE_BUDGET SET expense = 0 WHERE BUDGET_TYPE = 'Exclusive_Rental'

UPDATE DEP_G_A_EXPENSE_BUDGET SET expense = 0 WHERE BUDGET_TYPE = 'Rental'

UPDATE DEP_S_G_A_EXPENSE_BUDGET SET expense = 0 WHERE BUDGET_TYPE = 'Exclusive_Rental'

UPDATE DEP_S_G_A_EXPENSE_BUDGET SET expense = 0 WHERE BUDGET_TYPE = 'Rental'`ifdp`