Select sum(a.bucks + a.does) as total, date from scout_detail a, scout_header b where a.scoutid=1 and a.scoutid=b.scoutid and a.date=b.scout_date group by date Pick a Graph from the Dropdown box to show