title: Giving an alias to a subquery containing a join in access
body: <p>I am more experienced with SQL server's T-SQL but i have been working in Access. My question is how to give an alias to a sub query that has its own join operation. I believe i am talking about nested join operations. I know that i could create a seprate query but i dont have another need for it and would like to keep the object list as clean as possible. My current code is as follows, i am only showing the from statement as that is the source of the error:</p>
  
  <pre><code>FROM 
  (
    (
      tblPropertySpecs 
      INNER JOIN 
      (
        tblAssignedBuildingTypes 
        INNER JOIN qryAllPropertyIDs 
        ON tblAssignedBuildingTypes.PropertySpecID = qryAllPropertyIDs.PropertySpecID
      ) 
      ON (tblPropertySpecs.PropertySpecID = tblAssignedBuildingTypes.PropertySpecID) 
      AND (tblPropertySpecs.PropertySpecID = qryAllPropertyIDs.PropertySpecID)
    ) 
    INNER JOIN 
    (
      tblRefConstructionTypes 
      INNER JOIN tblAssignedConstructionTypes 
        ON tblRefConstructionTypes.ConstructionTypeID = tblAssignedConstructionTypes.ConstructionTypeID
    ) 
    ON tblAssignedBuildingTypes.AssignedBuildingTypeID = tblAssignedConstructionTypes.AssignedBuildingTypeID
  ) 
  LEFT JOIN 
  (
    tblRefFireSafetyDetectMethods 
    INNER JOIN tblAssignedFireSafetyDetections 
      ON tblRefFireSafetyDetectMethods.FireSafetyDetectedID = tblAssignedFireSafetyDetections.FireSafetyDetectedID
  ) [q1] 
  ON tblAssignedBuildingTypes.AssignedBuildingTypeID = q1.AssignedBuildingTypeID
  WHERE (((qryAllPropertyIDs.Status)="Active"));
  </code></pre>