title: Multiple Inner Join on different tables in MS ACCESS
body: <p>HI i have a patient information table and a master look up table, patient info contains the value data and its text is fetched from mstMasterLookup table.
  The following code sample was working fine in mysql but in access its causing error.</p>
  
  <p>can any one provide suggestion on this. how to acheive this functionality in Access</p>
  
  <pre><code>    SELECT 
     PatientInformations.[Study_Id], 
     tblHospital.Text_data as Hospital, 
     tblGender.Text_data as Gender
  FROM 
  
  PatientInformations
  
  INNER JOIN 
  
  (SELECT text_data,Value_data
              FROM mstMasterLookup
              WHERE mstMasterLookup.Table ='Hospital'
              AND Is_Active = true) tblHospital
                  ON tblHospital.Value_data =cstr( PatientInformations.Hospital_Id)
  
  INNER JOIN  (SELECT text_data,Value_data
              FROM mstMasterLookup
              WHERE mstMasterLookup.Table ='Gender'
              AND Is_Active = true) tblGender
  ON tblGender.Value_data =cstr( PatientInformations.Gender);
  </code></pre>