I have three tables (simplified version), words
, translations
, languages
.
words
id | key |
------------|
1 | sport |
2 | league |
3 | accept |
languages
id | name |
------------|
1 | English|
2 | Italian|
3 | German |
translations
id | word_id | language_id | translation |
-----------------------------------------|
1 | 1 | 1 | Sport |
2 | 1 | 2 | Sport |
3 | 3 | 2 | Accettare
Is there a way, using mySql, to get this result:
----------------------------------------------|
sport | Sport | Sport | Sport |
league | Leaugue | Liga | Lega |
accept | Accept | Akzeptieren | Accettare|
I tried using group by and group_concat, but it's not really what I need. I need it separated by languages and grouped by key.