hi,

i don't have pk,becuse i get this data from excel sheet every 3 months,
convertit to vfp.dbf.
and most of fields duplicated ,

delete from table1 where table1.pk in (select Pk from crsRand)


thanks.
m.qasem