As long as there is duplicate information in the tables your query will always return information that you may not want.

(RB , 11, Apple, FR), <--- Same as last line
(PM, 12, Apricot, GB), <---- Same as 4th line
(RB , 14, Aubergine, TR),
(PM, 12, Orange, FR), <--- Same as second line
(RB, 11, Banana, GB) <---- Same as first line

Select table1.ID, table1.Name, table1.texttype table1.langid inner join table2.langid, table2.description

The above query may have the inner join incorrect but it is a start, I do not have Oracle to test it with.