Group By Problem

[eluser]rochellecanale[/eluser]
I have an idea but i dont know how to combine the two queries in one simple query, like a subquery statement.
Here's my idea. First i run this query.

Code:

//First for earned type
mysql> select sum(amount) as total,fkmember from points_ledger where type = 'EARNED' group by fkmember;

//It results to

+-------+----------+
| total | fkmember |
+-------+----------+
|    30 |        1 |
|     5 |       37 |
|     5 |       47 |
|     5 |       53 |
+-------+----------+
4 rows in set (0.00 sec)

Code:

//Next is this for payout type

mysql> select sum(amount) as total,fkmember from points_ledger where type = 'PAYOUT' group by fkmember;

//results to
+-------+----------+
| total | fkmember |
+-------+----------+
|   -30 |        1 |
|    -5 |       37 |
|    -5 |       47 |
|    -5 |       53 |
+-------+----------+

Now how can i combine the two queries?