multi query 5 tables with only 1 ID, join query to get result from the 5 table
About my tables, I am creating a script for a game I like to play, if people has XYZ statement assigned to their account. Its based on 4 tables. 1 table with the past games saved with a match ID, then the next table holds match ID to player ID relation, table 3 then hold the player ID with the in-game ID whereas the last table holds info about what statement is assigned to them.
multi query 4 tables with only 1 ID. Table1 -> table2 -> table3 -> table4
About my tables, I am creating a script for a game I like to play, if people has XYZ statement assigned to their account. Its based on 4 tables. 1 table with the past games saved with a match ID, then the next table holds match ID to player ID relation, table 3 then hold the player ID with the in-game ID whereas the last table holds info about what statement is assigned to them.
multi query 4 tables with only 1 ID. Table1 -> table2 -> table3 -> table4 (Not looking for final script, but a guideline as where to start)
Let me start by stating that I am not looking for help creating the full query, I am however looking for some guideline as to how to start the query and what query statements I will be needing. A little hint on why each statement is needed would be nice too. I love learning and wanna learn how to do this kind of query, I tried google and other searches, but since I am not fully sure what I am gonna need, nothing has helped so far, so I won’t even be able to provide SQL query for what I got so far, since I got nothing. So I hope there is a kind soul that can give some guidelines.