dreampolice
Technical User
I have two Access 2003 tables:
TableMain
TablePerson
I would like to get this output if I query for a MID number such as 3:
My attempt below only fetches one name and ignores the TE value.
Another example if I query for MID number 5 I should get this:
Please advise
TableMain
Code:
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
Code:
PID FIRSTNAME LASTNAME
1 Joe Smith
2 Cal Jones
3 Bill Carson
I would like to get this output if I query for a MID number such as 3:
Code:
Firstname Lastname Firstname2 Lastname2 Info
Joe Smith Bill Carson OIUOI
My attempt below only fetches one name and ignores the TE value.
Code:
select * from TablePerson INNER JOIN TableMain on
TablePerson.PID = TableMain.PO
where TableMain.MID = 3
Another example if I query for MID number 5 I should get this:
Code:
Firstname Lastname Firstname2 Lastname2 Info
Cal Jones Cal Jones DFE
Please advise