title: How to write sub-query in Hyperledger Composer query?
body: <p>I want to write a complex query in Hyperledger Composer base on this SQL code. Can anyone help me to solve this problem?</p>
  
  <pre><code>SELECT column-names
    FROM table-name1
   WHERE value IN (SELECT column-name
                     FROM table-name2 
                    WHERE condition)
  </code></pre>