Running a query that retrieve data from more than one table

[Gustavo Lermen]

Hi

Is it possible to run a query that retrieve data from more than one table using the CRecordset class?
Ex: "Select Table1.Name from Table1,Table2 where Table1.Number = Table2.Number "


If so, how can I do this?

thanks...