title: SQL results in one row
body: <p>I have following statement:</p>
  
  <pre><code>SELECT        
      Person.PersonID, Person.PersonName, Person.Surname, 
      Address.Street, Address.PostCode,
      (SELECT Phones.Num
       WHERE (Phones.CommunicationTypeId = '78')) AS email, 
      (SELECT Phones.Num
       WHERE (Phones.CommunicationTypeId = '83')) AS mobile,
      (SELECT Phones.Num
       WHERE (Phones.CommunicationTypeId = '88')) AS phone
  FROM     
      Address 
  RIGHT OUTER JOIN
      Person ON Address.ObjectId = Person.PersonID 
  RIGHT OUTER JOIN
      Phones ON Person.PersonID = Phones.ObjectID
  </code></pre>
  
  <p>Now results shows separate rows, while I want to have it in one row:</p>
  
  <p><a href="https://i.stack.imgur.com/nWYp9.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/nWYp9.jpg" alt="enter image description here"></a></p>
  
  <p>How to consolidate it into just one row?</p>