title: Combine two query and display in single line
body: <p>I am using the below code to find the sales by credit card and cash and the current output show as below but I want to get the card and cash sales in single line.</p>
  <p>current output:</p>
  <p><img src="https://i.stack.imgur.com/sx4vN.jpg" alt="Current Output" /></p>
  <p>expected output:</p>
  <p><img src="https://i.stack.imgur.com/gFYcX.jpg" alt="Expected Output" /></p>
  <pre><code>SELECT CONVERT(VARCHAR(10), CreateDate, 103) DT,SUM(AMOUNT),NULL FROM JnlDetails WHERE  JnlDetails.CreateDate &gt; '2021-05-01' 
  AND ACCOUNTID = '000153200101'
  GROUP BY CONVERT(VARCHAR(10), CreateDate, 103)
  UNION ALL
  SELECT CONVERT(VARCHAR(10), CreateDate, 103) DT,NULL,SUM(AMOUNT) FROM JnlDetails WHERE  JnlDetails.CreateDate &gt; '2021-05-01' 
  AND ACCOUNTID = '000153200201'
  GROUP BY CONVERT(VARCHAR(10), CreateDate, 103)
  ORDER BY DT
  </code></pre>
  <p>Is there any other option available to achieve this without Union? Both the information's (Card and Sales) in the same table, based on the accountid we can split.</p>