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

[Bonum Monstrum]

Thanks alot for your help. Unfortunately, when i enter the code it says

"MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '/18
union all
select 2 as season, player, goals from table2
) sums
group by player;' at line 4"

I checked it, my Maria DB version is 10.1. Is there a way to get it work?


AND: can i easily add more tables to this code? for example

"select 3 as season, player, goals from table2
select 4 as ...."

Thanks a lot in advance! :)