title: I am trying to execute the following query but got (Error Code: 1242. Subquery returns more than 1 row)
body: <pre><code>SELECT ID, loan_num, borrower_name, loan_type, 
         (select document_name AS docs_uploaded 
          FROM document_list 
          WHERE document_list.document_id IN (closing_docs.docs_uploaded)), 
          docs_exceptions 
  FROM closing_docs ORDER BY datetime DESC;
  </code></pre>
  
  <p>Give some suggestions for above query.</p>