MySQL Forums
Forum List  »  Newbie

MySQL Database Tables connect Help (JOIN / SUM)
Posted by: Bonum Monstrum
Date: July 23, 2018 11:40AM

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!

Options: ReplyQuote

Written By
MySQL Database Tables connect Help (JOIN / SUM)
July 23, 2018 11:40AM

Sorry, only registered users may post in this forum.

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.