access 2007 query problem

[jassie]

Can you tell me what is wrong with this query using access 2007? can I have two inner joins?



SELECT mp.MRH_Id, mp.MRP_Plan_Id, mp.MRH_Create_Date, mp.MRH_Submitter, mp.MRH_Batch_Id, mp.MRH_Request_Status, mp.TRC_Code_Id, mp.MRH_Tran_Count, mp.MRH_Batch_Size, mp.MRH_Batch_Percent, mp.MRH_Tran_Code_Description
FROM mp INNER JOIN MPlans ON mp.MRP_Plan_Id = MPlans.MRP_Plan_Id
INNER JOIN MR_Transaction_Reply_Codes ON mp.TRC_Code_Id = MR_Transaction_Reply_Codes.TRC_Code_Id;

[June7]

Yes. What happens when you run query, error message, wrong results?

Would have to know more about your data, what relationships are, what output you want.