1 Reply Latest reply on Apr 9, 2011 2:28 AM by smargh

    Select doubt

      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')

      )

        • Re: Select doubt
          smargh

          SELECT


          (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')))


          AS ColumnTitleHere