>Dear Sir,
>
>I have two tables the first is "Master" and the other is "Group".
>The both tables has common fields as
>
>code n(6)
>name c(40)
>
>For Group table, I want to copy, from Master table, only those codes that are not exists in Group table.
>
>Index is on code field.
>
>Please help

Also

use Master in 0
select master
index on code tag code
Use Group in 0
select group
index on code tag code
select Master
scan
if seek(master.code,"Group","code")
   * Ignore, "code" is already in group
else && add "code" to group
   append blank in group
   replace group.code with master.code,group.name with master.name in Group
endif
endscan