User table
USERID......Name.......STATUS
1.............Owen........active
2.............Tom.........active
3.............Jimmy.......active
4.............Eason.......Inactive


Log table
ID........USERID......LastAccess
1.........1.............10/21/2003
2.........1.............10/22/2003
3.........1.............10/23/2003
4.........2.............09/21/2003
5.........2.............09/25/2003
6.........3.............10/21/2003
7.........4.............10/21/2003

How can I form a SQL to pull out all the ACTIVE user from user table, plus the user lastest lastaccess date.

Report will looke like
1.............Owen........active........10/23/2003
2.............Tom.........active........09/25/2003
3.............Jimmy.......active........10/21/2003

SELECT u.userid, u.name, u.status, l.lastaccess
FROM U.user, L.log
Where u.status = 'active' and .....???????

Thanks for advice!