Re: MySQL Database Tables connect Help (JOIN / SUM)

[Peter Brawley]

This combines the two tables, and, once it's done renders table1 and table2 unnecessary ...

drop table if exists futbolseasons;
create table futbolseasons
select player, sum(goals)
from (
  select 1 as season, player, goals from table1
  union all
  select 2 as season, player, goals from table2
) sums
group by player;