title: How to join multiple select statements in SQL and display in different colums
body: <p>I wrote a query that joins two tables that shows the total <code>no. of appointments</code> and <code>leads</code> using the <code>union</code> keyword and I would like the result of this query to be displayed in two different columns, I am having a tough description   </p>
  
  <pre><code>SELECT COUNT(FilteredAppointment.createdbyname) AS Appointment
  FROM  FilteredBusinessUnit 
  INNER JOIN FilteredSystemUser 
      ON FilteredBusinessUnit.businessunitid = FilteredSystemUser.businessunitid 
  INNER JOIN FilteredAppointment 
      ON FilteredSystemUser.systemuserid = FilteredAppointment.createdby
  UNION
  SELECT COUNT(FilteredLead.fullname) AS Lead
  FROM  FilteredBusinessUnit 
  INNER JOIN FilteredSystemUser 
      ON FilteredBusinessUnit.businessunitid = FilteredSystemUser.businessunitid 
  INNER JOIN FilteredLead 
      ON FilteredSystemUser.systemuserid = FilteredLead.createdby
  WHERE (FilteredBusinessUnit.name IN (@Branch))
  </code></pre>
  
  <p>My desired result is:</p>
  
  <pre><code>CRITERIA | Appointment | Leads
  Total    | 200         | 123
  </code></pre>