title: MS Access: Selecting records from 1 table based on multiple records of another table's field
body: <p>My question would be: How can I SELECT records of 1 table, based on another table's multiple records with a specific field value?</p>
  <p>So I have 2 tables, both with 3 fields. Important to note, that [suti].[id] === [tartalom].[sutiid]. <br /></p>
  <p>My job would be to select all [suti].[nev] and [suti].[tipus] that have both &quot;G&quot; and &quot;To&quot; in [tartalom].[mentes]. However, &quot;G&quot; and &quot;To&quot; are recorded in separate records, and that is why I have a problem with this. <br /></p>
  <p>In this example I have written below, the only record that should be selected is Something2 || tortaszelet.</p>
  <p>How is this achieveable? Thank you for your help in advance :)</p>
  <p>Before anybody says, it's not me that did this data structure. This is what I have, and cannot change it.</p>
  <h1>Table 1: suti</h1>
  <h2>id || nev || tipus</h2>
  <hr />
  <p>1 || Something1 || torta <br />
  2 || Something2 || tortaszelet <br />
  3 || Something3 || pite <br /></p>
  <h1>Table 2: tartalom</h1>
  <h2>id || sutiid || mentes</h2>
  <hr />
  <p>1 || 1 || L <br />
  2 || 1 || To <br />
  3 || 2 || G <br />
  4 || 2 || To <br />
  5 || 3 || G <br /></p>