I have 3 Access 2003 tables:
TableMain
MID PO TE INFO
1 2 3 ABC
2 2 1 EREER
3 1 3 OIUOI
4 3 3 PERE
5 2 2 DFE
TablePerson
PID FIRSTNAME LASTNAME
1 Joe Smith
2 Cal Jones
3 Bill Carson
I can get this output if I query for a MID number such as 3:
Firstname Lastname Firstname2 Lastname2 Info
Joe Smith Bill Carson OIUOI
Here is the query:
SELECT TableMain.MID, TablePerson.PID , TablePerson.FIR STNAME,
TablePerson.LAS TNAME, TablePerson_1.F IRSTNAME, TablePerson_1.L ASTNAME,
TableMain.INFO
FROM TablePerson INNER JOIN (TableMain INNER JOIN TablePerson AS
TablePerson_1 ON TableMain.TE = TablePerson_1.P ID) ON TablePerson.PID
= TableMain.PO
WHERE TableMain.MID=3
Now if I have a third table (called NotesTable) how would I get that
info?
For example if I query for MID number 3, I should get this:
Firstname Lastname Firstname2 Lastname2 Info Notes
Joe Smith Bill Carson OIUOI
other data
Here is NotesTable
NID MID Notes
1 miscl notes here
2 3 other data
3 fan info
Please advise