title: converting linq .Any in subquery to sql
body: <p>I'm trying to learn linq..I have the following linq query..</p>
  
  <p>var abc = consumers.Where(w => plays.Any(x => x.consumerid == w.consumerid));</p>
  
  <p>I would appreciate if someone could help me with its corresponding sql query.</p>
  
  <p>consumers have just two fields.. consumerid and period both string.
  plays also have two fields.. consumerid and playid both string.</p>
  
  <p>Based on answer <a href="https://stackoverflow.com/questions/25283515/converting-linq-expression-to-sql-server-query">here</a>.. I tried abc.ToString() but that did not help..</p>