Insert into (Dbf(Alias(11))) (code, date, type, category, scode, lcode, sec); Select code, date, 1 as type, category, scode, lcode, sec from Dbf(Alias(6)) where admtd=1 order by category