3 Replies Latest reply on Apr 6, 2010 1:26 PM by ecklerwr1

    2 selects in the same query

    contracer

      Hi:

      I´m looking for any way to put 2 selects in the same query, with no success:

      select servername, keepalive, pollingcompletion from engines;

      union

      SELECT
      Nodes.NodeID AS NodeID, Nodes.Caption AS NodeName, Nodes.CPULoad AS CPULoad
       FROM
      Nodes
       WHERE 
      (
        (Nodes.Caption = 'solaris_010')
      )