Please help me how can I sum the result of 2 select 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')

)

On 09-04-2011 14:54, contracer wrote:

UNION ALL
http://dev.mysql.com/doc/refman/5.1/en/union.html
--
Luuk

On Apr 9, 8:54*am, contracer <contrace... (AT) gmail (DOT) com> wrote:
not sure that the sum of these two queries is what you really
want???? example: (nodes=3 + interfaces=6 = 9)???