select fra 2 tabeller med count og group

SELECT WEEKOFYEAR(DATE( FROM_UNIXTIME(dato))) AS valg , sum(forandring) AS antal FROM `veight_1` WHERE ny = 1 AND `dato` > '1451606400' AND dato < '1483142400' group by valg ORDER BY dato ASC

valg     antal     
53     -0.29
1     -0.45
2     -0.67
3     -0.40
4     -0.51
5     -0.63
6     -0.47
7     -0.10

valg     vaegt1     vaegt2     
8     -1.23     -1.23
42     NULL    NULL
23     11.39     29.33
2     -0.67     -0.33
36     NULL    NULL
17     -1.10     -1.29
49     NULL    NULL

 valg     vaegt1     vaegt2     
53     -0.29     -0.25
20     2.48     7.98
52     NULL    NULL
33     NULL    NULL
14     -1.15     -0.81
46     NULL    NULL 

valg vaegt1     vaegt2     
53     -0.29     -0.25
1     -0.45     -0.14
2     -0.67     -0.33
3     -0.40     0.09
4     -0.51     -2.01
5     -0.63     -0.38
6     -0.47     -0.48
7     -0.10     0.03

WHERE ny = 1 AND `dato` > '1451606400' AND dato < '1483142400' AND WEEKOFYEAR(DATE( FROM_UNIXTIME( `dato` ) )) = valg ) AS vaegt2
FROM `veight_2` AS a WHERE 1 GROUP BY valg