title: LINQ subquery IN
body: <p>I'm a newbie with the IQueryable, lambda expressions, and LINQ in general. I would like to put a subquery in a where clause like this :</p>
  
  <p>Sample code :</p>
  
  <pre><code>SELECT * FROM CLIENT c WHERE c.ETAT IN (
   SELECT DDV_COLUMN_VAL FROM DATA_DICT_VAL
   WHERE TBI_TABLE_NAME = 'CLIENT' AND DD_COLUMN_NAME = 'STATUS'
             AND DDV_COLUMN_VAL_LANG_DSC_1 LIKE ('ac%'))
  </code></pre>
  
  <p>How do I translate this in LINQ ?</p>