title: Oracle SQL String Contains a value from another Table
body: <p>I am looking to find a way to add a where clause where a string in one table contains data from a column in another table.</p>
  
  <pre><code>Select
  ID,
  Name,
  Group,
  List
  From EDG
  Where
  List Like '% (Select(Column X) FRom Diag)%'
  </code></pre>
  
  <p>I'm looking for something that would work like you see above.  There are no columns to join on for the tables, it is just List in EDG can contain values from column X in Diag.</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Thanks,</p>