[web2py] SQL Query Help Using DAL

[David J.]

I am trying to display chat message information;

I have 2 tables
The first table is the auth table define in web2py

The second is this

db.define_table('messages',
    Field('from',db.auth_user),
    Field('to',db.auth_user),
    Field('msg','string'),
    Field('ts','datetime',default=request.now)
)

What I want to do do now is create a report on how many messages where 
sent and received by each user;

I want the output to look like this

user, messages sent, messages received
Joe User,15,20
User 2,20,15


I am trying to figure it out using DAL and grouping but this is way over 
my head;

Any help would be appreciated.

Thanks.

David.