>>What exactly goes wrong?
>>
>Sorry about that, I was getting "SQL: queries of this type are not supported".
>I think it expect a field name like nRecno rather than a function like recno() in that syntax.
>
>Jun

I dotn really know why it doesnt work, a few things to try

SELECT RECNO() AS nRecNo, * ;
   FROM TableA ;
   INTO CURSOR C_Tmp

SELECT TableA.* ;
   FROM TableA, TableB ;
   WHERE TableA.nRecNo = TableB.nRecNo
   INTO CURSOR TableC

Im not sure of the best way to pose it as an SQL Statement,
Could also do something like

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
ENDSCAN

Havnt tested the code, so might not work :)