SQL - Ayuda Query SQL

Buenas noches,

Me gustaria unir estos dos "select" y que el resultado fuera solo dos columnas:

SELECT c.masterGroup, COUNT(p.playerId) AS "TOTAL PROD" FROM customers c , players p WHERE c.customerId=p.ownerId
AND p.isBillable=1 GROUP BY c.masterGroup;

SELECT c.masterGroup, COUNT(p.playerId) AS "TOTAL DEMO" FROM customers c , players p WHERE c.customerId=p.ownerId
AND p.isBillable=0 GROUP BY c.masterGroup;


Lo he probado con :

SELECT

c.masterGroup as MasterGroup,
(SELECT count(po.playerId)
FROM players po
WHERE po.isbillable = 1
) as "TOTAL PROD",

(SELECT count(po.playerId)
FROM players po
WHERE po.isbillable = 0
) as "TOTAL DEMO"

FROM players p , customers c
WHERE p.ownerID=c.customerId
GROUP by c.masterGroup


Pero no me sale el resultado esperado.

Quien me puede ayudar?

Debes hacerlo con UNION

TUPRIMERA CONSULTA
UNION
TUSEGUNDA CONSULTA

Ambas consultas deben tener el mismo numero de columnas

El resultado son dos columnas : MASTERGROUP y TOTAL PROD y tambien necesito la tercera columna TOTAL DEMO, eso tambien lo habia probado.


(SELECT c.masterGroup, COUNT(p.playerId) AS "TOTAL PROD" FROM customers c , players p WHERE c.customerId=p.ownerId
AND p.isBillable=1 GROUP BY c.masterGroup)

UNION

(SELECT c.masterGroup, COUNT(p.playerId) AS "TOTAL DEMO" FROM customers c , players p WHERE c.customerId=p.ownerId
AND p.isBillable=0 GROUP BY c.masterGroup)

¿Alguna ayuda mas?

gracias por todo.

Muestranos que resultado te da y cual es el que esperas