Re: Newbie: combining two selects

"tuxfan" <blank_at_mail.box> a écrit dans le message de news: pan.2006.07.31.20.00.55.948654_at_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
|

SELECT node_data.server, COUNT ( node_data.node_name ),

             COUNT(DECODE(SIGN(2-lastacct),-1,1)) FROM node_data, account
WHERE node_data.node_name = account.node_name AND acct_number = '7777'
GROUP BY node_data.server
/

Regards
Michel Cadot Received on Mon Jul 31 2006 - 23:43:36 CDT