clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 756694 fiddles created (13655 in the last week).

create table words (id integer, lang integer, word varchar(100));
 hidden batch(es)


insert into words values (1, 1, 'Apfel');
1 rows affected
 hidden batch(es)


insert into words values (2, 0, 'Apple');
1 rows affected
 hidden batch(es)


insert into words values (3, 1, 'Birne');
1 rows affected
 hidden batch(es)


insert into words values (4, 0, 'Pear');
1 rows affected
 hidden batch(es)


create table translations (from_word integer, to_word integer);
 hidden batch(es)


insert into translations values (1, 2);
1 rows affected
 hidden batch(es)


insert into translations values (2, 1);
1 rows affected
 hidden batch(es)


insert into translations values (3,4);
1 rows affected
 hidden batch(es)


insert into translations values (4,3);
1 rows affected
 hidden batch(es)


select d.word as wort_deutsch, e.word as wort_englisch from words d join translations tr on d.id = tr.from_word join words e on e.id = tr.to_word and e.lang = 0 where d.lang = 1;
WORT_DEUTSCH WORT_ENGLISCH
Apfel Apple
Birne Pear
 hidden batch(es)