SELECT RECNO() AS nRecNo, * ; FROM TableA ; INTO CURSOR C_Tmp SELECT TableA.* ; FROM TableA, TableB ; WHERE TableA.nRecNo = TableB.nRecNo INTO CURSOR TableCIm not sure of the best way to pose it as an SQL Statement,
SELECT * FROM TableA WHERE .F. INTO TABLE TableC SELECT TableB SCAN SELECT TableA GO TableB.nRecNo SCATTER MEMVAR SELECT TableC APPEND BLANK GATHER FROM MEMVAR ENDSCANHavnt tested the code, so might not work :)