I have created database like this: I have inside my database about 20 languages and around 3mil translations. What is the best query to call list of translations for one word in particular languages to another? And can someone explain me this: I have for exp this base: LANGUAGE LANGUAGE_ID | LANGUAGE_NAME 1|'english' 2|'german' 3|'spain' WORD WORD_ID | LANGUAGE_ID | WORD_TEXT 1|'1'|'house' 2|'1'|'home' 3|'2'|'haus' 4|'3'|'casa' TRANSLATION WORD_ID1 | WORD_ID2 1|3 3|1 1|4 4|1 2|3 3|2 2|4 4|2 4|3 3|4 Code (markup): And someone want to translate word 'home' to German what query I must do? Is this good database for dictionary?