here is the Query
Code: Select all
$query = 'SELECT user_name,id,SUM(kills) as kills,SUM(wins) as wins,SUM(draws) as draws,SUM(bonus) as bonus FROM (
SELECT user_name, COUNT(id) as id, SUM(kills) as kills, SUM(wins) as wins, SUM(draws) as draws, SUM(bonus) as bonus FROM reports GROUP BY user_name
UNION all
SELECT user_name, COUNT(id) as id, SUM(kills) as kills, SUM(wins) as wins, SUM(draws) as draws, SUM(bonus) as bonus FROM reports2 GROUP BY user_name
UNION all
SELECT user_name, COUNT(id) as id, SUM(kills) as kills, SUM(wins) as wins, SUM(draws) as draws, SUM(bonus) as bonus FROM reports3 GROUP BY user_name
) t GROUP BY user_name';
answer for that is each table has different fields except for these 6 fields each table is for a different game played.