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