title: MS-SQL problem - Only one expression can be specified in the select list
body: <p>I write the following query:</p>
  
  <pre><code>select 
     id, 
     (select NameEn from [Campaign] where id=CampaignId) as CampaignName,    
     createdDate, 
     (select Name, IdNo, Email, MobileNo from [Members] where id=MemberId) 
  from 
     Transactions
  </code></pre>
  
  <p>and error occurs:<br>
  "Only one expression can be specified in the select list when the subquery is not introduced with EXISTS."</p>
  
  <p>How can I rewrite the SQL to make it correct?</p>