This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

2 selects in the same query

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