[MYSQL] Zapytanie łączne Opcje

[Exenatus]

Witajcie,

mam taki problem z zapytaniem gdzie jest błąd:

[SQL] pobierz, plaintext 
SELECT u.id AS id, u.name AS imie, u.surname AS nazwisko, w.punkty FROM user u, 
 (
   SELECT id, SUM(wynik) AS punkty FROM 
   (
         SELECT i.user_id AS id, 200*COUNT(i.user_id) AS wynik FROM invite i GROUP BY i.user_id 
          UNION 
          SELECT p.user_id AS id, 50*COUNT(p.user_id) AS wynik FROM player p GROUP BY p.user_id
    ) 
  GROUP BY id 
)w 
[SQL] pobierz, plaintext 

#1248 - Every derived table must have its own alias

struktura tabel:

user
id | emial | pass | name | surname | faculty | nr_indexu | token | akt | newsletter | admin

player
id | comp_id | user_id | answer

invite
id | user_id

próbuje wszystkiego i nie wiem jaki błąd jest w zapytaniu... proszę o pomoc.

Ten post edytował Exenatus 11.01.2011, 17:09:28

[wookieb]

[SQL] pobierz, plaintext 
SELECT u.id AS id, u.name AS imie, u.surname AS nazwisko, w.punkty FROM user u, 
 (
   SELECT x.id, SUM(x.wynik) AS punkty FROM 
   (
         SELECT i.user_id AS id, 200*COUNT(i.user_id) AS wynik FROM invite i GROUP BY i.user_id 
          UNION 
          SELECT p.user_id AS id, 50*COUNT(p.user_id) AS wynik FROM player p GROUP BY p.user_id
    )  x
  GROUP BY x.id 
) w 
[SQL] pobierz, plaintext 

[Exenatus]

Dziękuje!