title: Implementing INTERSECT (INNER JOIN) in MS ACCESS
body: <p>I've been looking at how to convert what I have as UNION to INTERSECT, but there is no INTERSECT keyword in MS Access.</p>
  
  <p>I've been very confused as to how the following code would look like using inner join if I wanted the intersection of these two select statements instead of the Union of them.</p>
  
  <p>I know I can achieve what I want if I SELECT DISTINCT and then use inner join but the ON keyword really confuses me.</p>
  
  <p>I just started a week ago with SQL so if you see anything else wrong with the code I'll accept all constructive criticism :)</p>
  
  <pre><code>SELECT *
  FROM (SELECT [Catt].[Name]
  FROM [Catt]
  WHERE ((([Catt].[Name]) Like "*" &amp; [forms]![Main]![SrchText] &amp; "*") 
  AND [forms]![Main]!   [SrchText] IS NOT Null AND [forms]![Main]![SrchText]&lt;&gt;''  )
  
  UNION
  
  SELECT [Catt].[Name]
  FROM [Catt]
  WHERE  ((([Catt].[Category]) Like [forms]![Main]![Combo7].Value) AND (([forms]![Main]!    [SrchText] IS Null) OR ([forms]![Main]![SrchText]=''))))  AS Query
  ORDER BY [Catt].[Name];
  </code></pre>
  
  <p>Thank you.</p>