title: replace multiple left joins in access sql
body: <p>I m writing a query in <strong>ms access</strong> for three tables "Process Name", "Work_Log1" and "ACn_reviewer".</p>
  
  <p>Now the "Work_Log1" table is having foreign keys to the "Process NAme" and "ACN_REviewer" table. </p>
  
  <p>But the "Work_log1" table is having null values in some rows for "ACN_Reviewer" table.</p>
  
  <p>THe <strong>working</strong> query i have come up with</p>
  
  <pre><code>select w.[activity_id], w.[activity_start_date], w.[reporting month] , 
  r.[Reviewer_Name] , p.[process_name]
  from [process name] p left join 
  ([work_log1] w left join [acn_reviewer] r
  on w.[ACN Reviwer] = r.[ACN_Reviewer_ID]  )
  on w.[process] = p.[process_id] 
   where w.[activity_id] = 54447 
  </code></pre>
  
  <p>now i know that there are no process ids null in the work_log1 table.</p>
  
  <p>The question i ask is there some way to do the above query without the joins?</p>
  
  <p>Something like this, left join only on acn_reviewer</p>
  
  <pre><code> select w.[activity_id], w.[activity_start_date], w.[reporting month] , 
  r.[Reviewer_Name] , p.[process_name]
  from [process name] p  ,   [work_log1] w left join [acn_reviewer] r
   on w.[ACN Reviwer] = r.[ACN_Reviewer_ID]   
    where w.[process] = p.[process_id] and 
    w.[activity_id] = 54447 
  </code></pre>
  
  <p>I hope now i m clear</p>
  
  <p>So can i write something like this in the sql, which is throwing error in ms-access</p>
  
  <pre><code>select w.[activity_id], w.[activity_start_date], w.[reporting month] ,
  r.[Reviewer_Name] , p.[process_name] from [process name] p, [work_log1] w 
  left join [acn_reviewer] r
  on w.[ACN Reviwer] = r.[ACN_Reviewer_ID]  on w.[process] = p.[process_id]
   where w.[activity_id] = 54447 ;
  </code></pre>
  
  <p>Thanks</p>
  
  <p>Pradyut</p>