International SQL-Ledger Network Association

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;