title: Have subquery in a SELECT return more than one value
body: <p>I have a subquery that if it returns more than one value, they show in the same column but different line with all the other information would be the same and just the result the result of the subquery would be different.</p>
  <p>As it is now, I'm getting an error</p>
  <blockquote>
  <p>Subquery returned more than 1 value but no operator</p>
  </blockquote>
  <p>The part that matters about my code is:</p>
  <pre><code>SELECT 
      TABLE1.ID_Cota,
      (SELECT Observacao 
       FROM TABLE2
       INNER JOIN TABLE2A ON TABLE2.ID_TABLE2 = TABLE2A.ID_TABLE2
                          AND TABLE2.ID_COTA  = COTAVINCULADA.ID_COTA_MAE
                          AND TABLE2.ID_OCORRENCIA_CONTEMPLACAO = 335) AS 'OBSERVACAO_COTA_MAE_335',
      FASE335A.OBSERVACAO AS 'OBSERVACAO_COTA_VINCULADA_335'
  FROM 
      TABLE1
  LEFT JOIN
      ...
  </code></pre>
  <p>If all the code is needed, please let me know.</p>