CREATE VIEW VistaVentasCliente AS SELECT c.ID_CLIENTE, c.NOMBRES, c.APELLIDOS, d.NOMBRE_DISTRITO, ISNULL(COUNT(b.ID_BOLETA),0) AS 'CANTIDAD DE BOLETA' FROM CLIENTE c INNER JOIN DISTRITO d ON c.ID_DISTRITO = d.ID_DISTRITO LEFT JOIN BOLETA b ON c.ID_CLIENTE = b.ID_CLIENTE GROUP BY c.ID_CLIENTE, c.NOMBRES, c.APELLIDOS, d.NOMBRE_DISTRITO; SELECT * FROM VistaVentasClientes;