Home > other >  How to SUM the result of two different SQL query?
How to SUM the result of two different SQL query?

Time:04-14

I want to SUM these two different queries. I joined both with USING function. but it shows the two results in two different cells.

I need a single result to SUM these two queries where the answer should be 4069.

The CODE

SELECT COUNT(*) Active_Projects FROM
(SELECT ProjectID, ProjectStatusID, ClientID
FROM project) a
INNER JOIN 
(SELECT ProjectStatusID, ClientID, ProjectStatusName
FROM ProjectStatus) b
ON (a.ProjectStatusID = b.ProjectStatusID AND a.ClientID = b.ClientID)
WHERE ProjectStatusName LIKE '           
  • Related