SQL question -- is it possible to do this?

[Ken Shamrock]

Table1 Table2
+-----------+--------++-----------+----------+------+
| ip        | name   || ip        | time     | hits |
+-----------+--------++-----------+----------+------+
| 127.0.0.1 | local1 || 127.0.0.1 | 2002-7-1 | 100  |
| 127.0.0.2 | local2 || 127.0.0.1 | 2002-7-2 | 200  |
| 127.0.0.3 | local3 || 127.0.0.2 | 2002-7-1 | 300  |
+-----------+--------++-----------+----------+------+

mysql> select a.ip,name,time,sum(hits) from table1 a left join table2 b on a.ip=
b.ip group by a.ip,a.name;

+-----------+--------+------+-----------+
| ip        | name   | time | sum(hits) |
+-----------+--------+------+-----------+
| 127.0.0.1 | local1 | 2002 |       300 |
| 127.0.0.2 | local2 | 2002 |       300 |
| 127.0.0.3 | local3 | NULL |         0 |
+-----------+--------+------+-----------+

mysql> select a.ip,name,time,sum(hits) from table1 a left join table2 b on a.ip=
b.ip where time>'2001' OR time=null group by a.ip,a.name;

+-----------+--------+------+-----------+
| ip        | name   | time | sum(hits) |
+-----------+--------+------+-----------+
| 127.0.0.1 | local1 | 2002 |       300 |
| 127.0.0.2 | local2 | 2002 |       300 |
+-----------+--------+------+-----------+

[ edited to preserve formatting using the [code] and [/code] UBB tags -ds ]
[ July 18, 2003: Message edited by: Dirk Schreckmann ]

[Ken Shamrock]

Please read the question in this link as the above is hard to read:
http://www.hk3s.com/db.txt