multiple table joins

[jazzgirl]

I have Access 2007 database that I would like to join 4 tables on. I know that I need to use paranthesis (), however whatever I try does not work. Every is not joining everything from the main table called MRJ. I am also joining from a second table called MR_Plan.

I also need to use the query designer to display a graphically representation of the joins for documenting new queries i am writing. I am basically needing to write design specifications before I write the queries.

Thus can you tell me how to write the sql for the joins listed below:

I would like
SELECT MRJ.*
FROM MRJ INNER join MR_Tran_Reply_Codes ON MRJ.TRC_Code_Id = MR_Tran_Reply_Codes.TRC_Code_Id
INNER JOIN MR_Plan ON MRJ.MRP_Plan_Id = MR_Plan.MRP_Plan_Id
INNER JOIN MR_People ON MR_Plan.MRP_Plan_Id = MR_People.MRP_Plan_Id;

 

[PNGBill]

This may assist you
http://msdn.microsoft.com/en-us/library/bb243855(v=office.12).aspx