title: How do i combine multiple select statements in separate columns?
body: <p>I have these three statements:</p>
  
  <pre><code>select count (distinct vid) as SUM_OF_SEC from pdalis where pid in(500,504);
  select sum (amount*paidperitem) SUM_OF_A from pdalis where pid = 501 ;
  select sum(amount * paidperitem) SUM_OF_P from pdalis where pid IN (500,504);
  </code></pre>
  
  <p>How do i combine all of them into 3 side by side columns?</p>