Delete old gifi accounts if any

    delete from gifi; 

Copy chart of accounts to gifi chart of accounts

    insert into gifi (accno, description) select accno, description from chart; 

update chart and set gifi account to account number    

    update chart set gifi_accno=accno;