Help: SELECT STATEMENT

From: JM <riper_at_yahoo.com>
Date: Tue, 14 Mar 2000 02:05:35 GMT
Message-ID: <P7hz4.31817$t7.1892238@news1.rdc2.tx.home.com>

I have following table:

Switch-column position-column Time

switchA                On                       1:00
switchA                Off                        2:00
switchD                On                        1:00
switchB                Off                        1:00
switchD                Off                        2:00
switchC                Off                        1:00
switchC                Off                        2:00


=============================

I need following output:

Switch        On-Total    Off-Total
switchA        1                1
SwitchB        0                1
SwitchC        0                2
SwitchD        1                1


==============================

As above the output is grouped by Switch column. I can't figure out how to split
position-column into "on-total' and "off-total" columns using SELECT statement.

Thanks in advance!
Manny Received on Mon Mar 13 2000 - 20:05:35 CST