SELECT a.client_num, a.NAME, a.DATE, a.price, a.client_src, ; b.ma_number AS ma_num, b.upin, b.dr_code AS drc, ; b.drv_code AS dvc, b.pr_author AS prior_auth, .T. AS SEND ; FROM ver a ; LEFT OUTER JOIN clients b ON a.client_num = B.client_num ; INTO ARRAY laWMA; WHERE ("WMA" $ a.client_src) ; AND (a.STATUS != "CXL") ; AND (a.STATUS != "NS") ; AND (NOT "C" $ a.meter) ; AND a.verified; AND NOT DELETED()After these are selected, they are copied into another table and deleted from the original table.