>If is select the data into record set, how i can using SQL command to "select " again from that record set , or select inner join with other table .
No. But if you are using AFO, you can apply a Filter on a recordset.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com