If I have table say A and another table Say B and if I want to insert records of Table B in Table A, I may do it like this,

Insert into A.DBF (Filed1) select Field1 from Table B.

But how to insert the Table B records if I want to insert the Table B records after the record Number 10 i.e Recno() 10 of Table A.

I.e How to insert Table B records in Table A after the Table A RECNO()>10