I don't know what worry in my program or in mfc

Hi:
In my application,I use MFC CRecordSet Class to access a Datebase(Access 7.0).In this Datebase,there are three table (named is files","subjects","units".
"files" have filesname,filesid,subjectid,"sujects" have sujectname,sujectsid,unitsid,"units"have unitsname unitid, such as.).
I select all in the wizard.When the sql"select * from files,suject and units where ....." it work well,but when I want to query only one table there is some error ,such this "select * from units",but the m_unisname is null,and the m_filename is the right string get from table,what's error with this,my program or mfc? I hoped you can help me!
thanks!
(my e-mail address is [email protected] )

[Masaaki]

Hi.

I'm wondering that your story is true?
Because Access is not rational database, VC just can deal with
only one table at one time. If you use VC Enterprise Editon and
SQL Server, you can write the stored procedure and VC deal with
the rational database system like Oracle, SQL server and so on.

Regards.
-Masaaki Onishi-