I wish to create a query where I do a number of counts on the same table but
with different filters.
ie:
count(id) as numrows
count(id) as inrows where direction = 'In'
count(id) as outrows where direction = 'Out'
Could I do the above in a single query?
| id | date | direction | duration | cost |
| 1 |2007-01-01| In | 56 | 0.00 |
| 2 |2007-01-01| Out | 60 | 0.10 |
| 3 |2007-01-02| Out | 47 | 0.10 |
| 4 |2007-01-02| In | 120 | 0.20 |
Thx
Lloydie T
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
