combining and aggregating two sql tables

Dutloonenut

New Member
I wrote a sql statement das returns an author, count of negative comments and count of positiv coments.Example output:Mike 3 4Daniel 5 6Mike 1 3And I'd like to aggregate Mike so that you have as result Mike 4 7. How can i do this as a sql query?Thanks
 
Top