Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL question -- is it possible to do this?

 
Ken Shamrock
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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;

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;
[ edited to preserve formatting using the [code] and [/code] UBB tags -ds ]
[ July 18, 2003: Message edited by: Dirk Schreckmann ]
 
Ken Shamrock
Ranch Hand
Posts: 139
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please read the question in this link as the above is hard to read:
http://www.hk3s.com/db.txt
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic