MySQL Database Tables connect Help (JOIN / SUM)
Hey Guys! I'm completely new to SQL. I have to Tables, Table1 and Table2.
Inside of them are data from different soccer players. Both have the exact same structure. For Example, Player A shot in Season 1 (Table1) 5 goals. In Season 2 (Table2) he shot 3 Goals.
I want to have a third table now (Table0), ich which all data is coming together. So in my Example, in Table0 Player A should have 8 Goals.
I have many Players and of course other statistics like passes and so on (all data should be added together (except the player name and the player ID, both are always same). But I'm not able to create Table0 the way I want, due to my lack of skills.
Hopefully one of you can help me out! :slight_smile:
Thanks a lot in advance!
Subject
Written By
Posted
MySQL Database Tables connect Help (JOIN / SUM)
July 23, 2018 11:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.