title: In SQL or MySQL, can we join a table and a subquery result?
body: <p>Can we join a table with the result of a subquery, such as:</p>
  
  <pre><code>select name from gifts
      LEFT OUTER JOIN (select giftID from gifts) ...
  </code></pre>
  
  <p>If not, can it be done by some methods, such as creating a temporary table?</p>
  
  <p>P.S. Can a subquery only appear using   IN or NOT IN, or EXISTS or NOT EXISTS? </p>