SQL Error

Hi,

I have three tables that are joined and I wanted to create a query that would return all records from one of the tables and only those matching from the other table.

I used Access properties window that does that; however, when I try to execute the query, it prints this message:

'The SQL statement could not be executed because it contains ambiguous outer joins. To force one the joins to be performed first, create a seperate query that performs the first join and then include that query in your SQL statement.'

This is my query:

SELECT tblSite.Site_No, tblPhase.Phase_No, tblSite.Name, tblHouse.House_ID, tblHouse.Plot_no, tblHouse.House_No, tblHouse.House_Address, tblHouse.House_P_Code, tblHouse.House_Type, tblHouse.Gross_Floor_Area, tblHouse.No_Of_Apartments, tblHouse.Number_Of_Bedrooms, tblHouse.House_Width, tblHouse.House_Depth, tblHouse.Garage, tblHouse.Phone, tblHouse.Electricity_Meter_Reading, tblHouse.Gas_Meter_Reading, tblHouse.Water_Meter_Reading, tblHouse.Customer_Handbook_Completed, tblHouse.Anticipated_Councial_Tax_Band, tblHouse.Missives, tblHouse.House_Price
FROM tblSite INNER JOIN (tblPhase RIGHT JOIN tblHouse ON tblPhase.Phase_No = tblHouse.Phase_No) ON tblSite.Site_No = tblPhase.Site_No;

I can't get it to work and I will appreciate any help please.

regards,
B