title: How can I SELECT records using a select list made of foreign keys?
body: <p>I have a table, DEBTOR, with a structure like this:</p>
  
  <p><img src="https://i.stack.imgur.com/7PN2s.png" alt="DEBTOR"></p>
  
  <p>and a second table, DEBTOR.INFO structured like this:</p>
  
  <p><img src="https://i.stack.imgur.com/lDGbp.png" alt="DEBTOR.INFO"></p>
  
  <p>I have a select list made of record IDs from the <strong>DEBTOR.INFO</strong> table. How can I </p>
  
  <p><code>select * from DEBTOR WHERE 53 IN (name of select list)</code>? </p>
  
  <p>Is this even possible?</p>
  
  <p>I realize this query looks more like SQL than RetrieVe but I wrote it that way for an easier understanding of what I'm trying to accomplish.</p>
  
  <p>Currently, I accomplish this query by writing </p>
  
  <p><code>SELECT DEBTOR WITH 53 EQ [paste list of DEBTOR.INFO record IDs]</code> </p>
  
  <p>but obviously this is unwieldy for large lists.</p>