alter table toTable add column note1 memo && make sure this field does not already exist, using a procedure for this purpose. USE fromTable IN 0 SELECT fromTable INDEX on thisID UNIQUE TO indexID && the key field SELECT fromTable && the memo field is in this table SCAN findThisID = thisID SELECT toTable && insert the memo field in this table IF SEEK(findThisID) REPLACE note1 WITH fromTable.note1 && all other rows/fields are unique as a result of using a select distianct * ... into table toTable && but the memo field is missing. So, find the key field and its memo in the fromTable && then insert the memo into the toTable. endif ENDSCAN