reenajasmine
asked on
multiple table in MFC
how to connect multiple table in MFC in a single dialog based app with header file
Use the class wizard.
Make a CRecordset class.
The interface will present all of your tables.
Click on all of the tables you want to join and click OK.
Back in your code, you will need to modify the m_strFilter as it will contain your WHERE clause.
The WHERE clause is very important as it will bind the results from one table to the other.
The m_strFilter will not need to include the word 'WHERE'.
Make a CRecordset class.
The interface will present all of your tables.
Click on all of the tables you want to join and click OK.
Back in your code, you will need to modify the m_strFilter as it will contain your WHERE clause.
The WHERE clause is very important as it will bind the results from one table to the other.
The m_strFilter will not need to include the word 'WHERE'.
My comment would be a way to achieve the desired effect
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
eg an SQL such as :
SELECT Adressen.Kurzname, Auftragsadressen.AuftragID
FROM Adressen INNER JOIN Auftragsadressen ON Adressen.PSID = Auftragsadressen.PSID;