AppWizard -> CDAORecordset for a join

Here's an MFC question:

I'm using AppWizard to build an app. I'd like to insert one CDAORecordset class to do a join across two tables. I couldn't get this to work, though. So, I inserted two classes and walked each table. This really sucks, and I'd rather do a join.

I'm starting to think the problem is that when I did an open I only referenced the one field across both tables I was interested in. Although this works in Access, I think it must be a problem within the Data Exchange to not list all fields on a select in the SQL for a Recordset open?

Does that make sense?

When I brake it up into two classes, it works fine!

Thanks in Advance!

Hmm...

Try to define the join query you want in Access and save it in the db. Then add a recordset class based on that query (not sure if the wizard can do it though).