Cacher is the code snippet organizer for pro developers

-- https://stackoverflow.com/questions/2804195/mysql-join-two-tables-and-add-column-values

SELECT    t1.date, t1.v1 + t2.v1 AS v1_sum, t1.v3 + t2.v3 AS v3_sum
FROM      table1 t1
JOIN      table2 t2 ON (t1.date = t2.date);

SELECT TopAlbums.artist, TopAlbums.album, Top5000.title, Top5000.year
FROM TopAlbums
INNER JOIN Top5000 ON TopAlbums.artist=Top5000.artist AND TopAlbums.year=Top5000.year;