mysql - Every derived table must have its own alias, i dont know how to fix

Question

I dont know how to fix this problem or why im getting it: Every derived table must have its own alias.

SELECT COUNT(*) FROM (
    SELECT COUNT(udelezba_akcije.Oseba_idOseba) AS `value_occurrence`  FROM udelezba_akcije
    INNER JOIN oseba ON udelezba_akcije.Oseba_idOseba = oseba.Ime_osebe
    GROUP BY udelezba_akcije.Oseba_idOseba
)

标签： mysqlsql

Answer 1

为其添加别名。最后一个字母就可以了。例如：

SELECT COUNT(*) 
FROM (
  SELECT COUNT(udelezba_akcije.Oseba_idOseba) AS value_occurrence 
  FROM udelezba_akcije INNER JOIN oseba ON udelezba_akcije.Oseba_idOseba = oseba.Ime_osebe 
  GROUP BY udelezba_akcije.Oseba_idOseba
) x

看到x我添加的了吗？而已。