I have two tables i would like to join to show bonus earned this month and total this year.
First table: empl.
emplID | Name
1 | Bob
2 | James
Second table: Bonus.
empl_id | month | Bonus
1 | 1 | 1000
2 | 1 | 750
1 | 2 | 500
2 | 2 | 1000...