Newbie: combining two selects

From: tuxfan <blank_at_mail.box>
Date: Mon, 31 Jul 2006 16:00:56 -0400
Message-Id: <pan.2006.07.31.20.00.55.948654@mail.box>

I am trying to combine the following two SQL statements into one select statement. The first column in both statements are the same. It looks like I need a nested statement, but I don't know how to do that.

SELECT node_data.server, COUNT ( node_data.node_name ) FROM node_data, account
WHERE node_data.node_name = account.node_name AND acct_number = '7777'
GROUP BY node_data.server

SELECT node_data.server, COUNT ( node_data.node_name ) FROM node_data, account
WHERE node_data.node_name = account.node_name AND acct_number = '7777'
AND lastacct < 2
GROUP BY node_data.server Received on Mon Jul 31 2006 - 15:00:56 CDT