title: get field in a single row from union query
body: <p>I have written a query that retrieve result from union. But it shows the result in two row and leave the blank column with 0. But I need the result in one row and no need the zeros. Can anyone please help me on this. Here are my query given below which I have written in two part >>></p>
  
  <pre><code> SELECT COUNT(gi.id) AS no_of_group ,
         0 AS no_of_borrower
  FROM group_info AS gi
  WHERE gi.domain_status_id = 1
    AND gi.group_status_id = 1
    AND gi.group_creation_date &lt;= '2013-01-31'
    AND gi.project_info_id = 'BI0000000000000000000001'
    AND gi.branch_info_id = 'BI0000000000000000000363'
  UNION
  SELECT 0 AS no_of_group ,
         COUNT(outerlat.member_info_id) AS no_of_borrower
  FROM
    (SELECT lat.member_info_id,
            MAX(lat.id) AS max_member_id
     FROM loan_account_transaction AS lat
     WHERE lat.project_info_id = 'BI0000000000000000000001'
       AND lat.country_id = 1
       AND lat.domain_status_id = 1
       AND lat.office_info_id = 'BI0000000000000000000363'
       AND lat.transaction_date &lt;= '2013-01-31'
     GROUP BY lat.member_info_id) AS tempData
  INNER JOIN loan_account_transaction AS outerlat ON (tempData.max_member_id = outerlat.id)
  WHERE outerlat.loan_status_id IN(1,3,4,5)
  </code></pre>