title: How to combine fields in OrientDB SQL SELECT statement
body: <p>I have this rather complicated query</p>
  
  <pre><code>SELECT FROM (
    SELECT EXPAND(INV()) FROM (
      SELECT FROM (
        SELECT EXPAND(OUTE('Streamed')) FROM (
          SELECT EXPAND(OUT('Follows')) FROM #12:3923
        )
      )
    )
  )
  </code></pre>
  
  <p>which can be described as:</p>
  
  <p>From the @rid #12:3923 which is a User class, find the Users that he follows and see which Post (vertex) they have Streamed (edge).</p>
  
  <p>Now with this, I would also like to have the username (User.username) from the person that Streamed each Post in the same row if possible.</p>