title: MYSQL with multiple SUBQUERIES
body: <p>Hi and thanks for reading.</p>
  
  <pre><code>SELECT DISTINCT (thisID and thisNAME) from table1 WHERE thisID IN
  (SELECT id from table2 WHERE ... condtions)
  OR 
  (SELECT id from table3 WHERE ... different condtions)
  OR 
  (SELECT id from table99 WHERE ...even more conditions)
  </code></pre>
  
  <p>I need to perform a few SELECTS to provide a nu,ber of thisID's  once I have these I need to select only thethisID and thisNAME from the table 1.  </p>
  
  <p>I must admit Im a little out of my depth with writing queries...but Im certain Im on the right lines?  Any help please??</p>