Hi,
Is there any way to sum the result of 2 queries ?
SELECT
COUNT(DISTINCT Nodes.Caption) AS COUNT_of_NodeName
FROM
Nodes
WHERE
(
(Nodes.Status = '1') AND
(Nodes.Link = 1)
)
SELECT
COUNT(Interfaces.InterfaceName) AS COUNT_of_Interface_Name
FROM
Interfaces
WHERE
(
(Interfaces.Link = 1) AND
(Interfaces.Status = '1')
)