I have two different tables that I have performed an inner join to but I need the query to count the number of values from both. When Running the query that is show below i get nothing.
And help is much appreciated
SELECT r.SId, a.Closed, Count (*) as Total
FROM Req r INNER JOIN Archive a on (a.requestid = r.requestid )
WHERE (((r.SId) ='H') AND ((a.Closed) IS NULL))
GROUP BY r.SId, a.Closed