title: Circular Reference in MS Access
body: <p>I'm getting a circular reference error in Microsoft Access SQL. </p>
  
  <pre><code>SELECT a.PlateNo, a.colm, a.alain
  FROM (SELECT PlateNo, alain, min(InspectionDate) AS colm
        FROM [Vehicle Spot Check] GROUP BY PlateNo)
    AS a
  INNER JOIN [Vehicle Spot Check] AS m
  ON (a.alain = m.WithoutDefects) AND (a.colm = m.InspectionDate)
    AND (a.PlateNo = m.PlateNo);
  </code></pre>
  
  <p>I'm getting this error: </p>
  
  <blockquote>
  <pre><code>Circular reference caused by alias '' in query definition's Select List. 
  </code></pre>
  </blockquote>
  
  <p>I dont know which one because there is no specified field. My main suspect is <code>m.WithoutDefects</code> but I already double checked. Is there any way to find this? What I'm thinking is also the syntax after the "Inner Join" as the problem.</p>