title: SQL Merging 4 Queries to one
body: <p>Im having a slight issue merging the following statements </p>
  
  <pre><code>    declare @From DATE
  SET @From = '01/01/2014'
  
  
  declare @To DATE
  SET @To = '31/01/2014'
  
  --ISSUED SB 
  
  SELECT
        COUNT(pm.DateAppIssued) AS Issued, 
        pm.Lender,
        pm.AmountRequested,
        p.CaseTypeID
  FROM  BPS.dbo.tbl_Profile_Mortgage AS pm
          INNER JOIN BPS.dbo.tbl_Profile AS p
              ON pm.FK_ProfileId =  p.Id 
  WHERE CaseTypeID = 2
  AND (CONVERT(DATE,DateAppIssued, 103) 
  Between  CONVERT(DATE,@From,103) and CONVERT(DATE,@To,103)) 
  And Lender &gt;  ''
  GROUP BY  pm.Lender,p.CaseTypeID,pm.AmountRequested;
  
  
  --Paased
  
  SELECT
        COUNT(pm.DatePassed) AS Passed, 
        pm.Lender,
        pm.AmountRequested,
        p.CaseTypeID
  FROM  BPS.dbo.tbl_Profile_Mortgage AS pm
          INNER JOIN BPS.dbo.tbl_Profile AS p
              ON pm.FK_ProfileId =  p.Id 
  WHERE CaseTypeID = 2
  AND (CONVERT(DATE,DatePassed, 103) 
  Between  CONVERT(DATE,@From,103) and CONVERT(DATE,@To,103)) 
  And Lender &gt;  ''
  GROUP BY  pm.Lender,p.CaseTypeID,pm.AmountRequested;
  
  
  --Received 
  
  SELECT
        COUNT(pm.DateAppRcvd) AS Received, 
        pm.Lender,
        pm.AmountRequested,
        p.CaseTypeID
  FROM  BPS.dbo.tbl_Profile_Mortgage AS pm
          INNER JOIN BPS.dbo.tbl_Profile AS p
              ON pm.FK_ProfileId =  p.Id 
  WHERE CaseTypeID = 2
  AND (CONVERT(DATE,DateAppRcvd, 103) 
  Between  CONVERT(DATE,@From,103) and CONVERT(DATE,@To,103)) 
  And Lender &gt;  ''
  GROUP BY  pm.Lender,p.CaseTypeID,pm.AmountRequested;
  
  
  
  --Offered
  
  SELECT
        COUNT(pm.DateOffered) AS Offered, 
        pm.Lender,
        pm.AmountRequested,
        p.CaseTypeID
  FROM  BPS.dbo.tbl_Profile_Mortgage AS pm
          INNER JOIN BPS.dbo.tbl_Profile AS p
              ON pm.FK_ProfileId =  p.Id 
  WHERE CaseTypeID = 2
  AND (CONVERT(DATE,DateOffered, 103) 
  Between  CONVERT(DATE,@From,103) and CONVERT(DATE,@To,103)) 
  And Lender &gt;  ''
  GROUP BY  pm.Lender,p.CaseTypeID,pm.AmountRequested;
  </code></pre>
  
  <p>Ideally I would like the result of theses query's to show as follows</p>
  
  <p>Issued, Passed , Offered, Received,
  All in one table</p>
  
  <p>Any Help on this would be greatly appreciated 
  Thanks
  Rusty</p>