Witam mam taki oto problem:
posiadam takie tabele
---- Player ----

[SQL] pobierz, plaintext 
 id | fname | lname
[SQL] pobierz, plaintext 

---- Match ---

[SQL] pobierz, plaintext 
 id | wynik | text
[SQL] pobierz, plaintext 

---- Match_Player ----

[SQL] pobierz, plaintext 
 id | id_player | id_team | id_match
[SQL] pobierz, plaintext 

---- Match_Goals ----

[SQL] pobierz, plaintext 
 id | shooter | assist_1 | assist_2 | id_match 
[SQL] pobierz, plaintext 

i chciałbym otrzymać taką tablę wyników :
---- Table ------

[SQL] pobierz, plaintext 
 fname | lname | total_match | total_goals | total_assist 
[SQL] pobierz, plaintext 

liczbę meczy mogę zliczyć tak

[SQL] pobierz, plaintext 
SELECT count(id_player) FROM match_player GROUP BY id_player
[SQL] pobierz, plaintext 

ale jak to wszystko pozlepiać ze sobą i dodać ze sobą dwie kolumny "assist" ?
Proszę o radę.
Pozdrawiam

A warunek sobie napisać nie sposób? Wystarczy sobie count robić a potem suma

wypociłem coś takiego

[SQL] pobierz, plaintext 
SELECT P.lname,P.fname, 
(SELECT COUNT(G.shooter) FROM match_goals AS G WHERE G.shooter = P.id GROUP BY G.shooter) AS  total_goals,
((SELECT COUNT(A1.assist1) FROM match_goals AS A1  WHERE A1.assist1 = P.id GROUP BY A1.assist1) +
(SELECT COUNT(A2.assist2) FROM match_goals AS A2  WHERE A2.assist2 = P.id GROUP BY A2.assist2)) AS total_assist,
(SELECT COUNT(PL.id_player) FROM match_players AS PL WHERE PL.id_player=P.id GROUP BY PL.id_player) AS total_match
FROM players AS P 
[SQL] pobierz, plaintext 

czy można to napisać lepiej ?