create table sorten(sortenid integer, gemuese varchar(20));
insert into sorten values(1, 'Tomate');
insert into sorten values(2, 'Gurke');
insert into sorten values(3, 'Rucola');
insert into sorten values(4, 'Bohne');
insert into sorten values(5, 'Kartoffel');
 
create table lieblingssorten(id integer, name varchar(20), a integer, b integer);
insert into lieblingssorten values(1, 'Anton', 3, 4);
insert into lieblingssorten values(2, 'Caroline', 1, 3);
 
    SELECT ls.name, s1.gemuese AS gemuese1, s2.gemuese AS gemuese2
    FROM lieblingssorten ls
    INNER JOIN sorten s1 ON ls.a = s1.sortenid
    INNER JOIN sorten s2 ON ls.b = s2.sortenid;

Y3JlYXRlIHRhYmxlIHNvcnRlbihzb3J0ZW5pZCBpbnRlZ2VyLCBnZW11ZXNlIHZhcmNoYXIoMjApKTsKaW5zZXJ0IGludG8gc29ydGVuIHZhbHVlcygxLCAnVG9tYXRlJyk7Cmluc2VydCBpbnRvIHNvcnRlbiB2YWx1ZXMoMiwgJ0d1cmtlJyk7Cmluc2VydCBpbnRvIHNvcnRlbiB2YWx1ZXMoMywgJ1J1Y29sYScpOwppbnNlcnQgaW50byBzb3J0ZW4gdmFsdWVzKDQsICdCb2huZScpOwppbnNlcnQgaW50byBzb3J0ZW4gdmFsdWVzKDUsICdLYXJ0b2ZmZWwnKTsKCmNyZWF0ZSB0YWJsZSBsaWVibGluZ3Nzb3J0ZW4oaWQgaW50ZWdlciwgbmFtZSB2YXJjaGFyKDIwKSwgYSBpbnRlZ2VyLCBiIGludGVnZXIpOwppbnNlcnQgaW50byBsaWVibGluZ3Nzb3J0ZW4gdmFsdWVzKDEsICdBbnRvbicsIDMsIDQpOwppbnNlcnQgaW50byBsaWVibGluZ3Nzb3J0ZW4gdmFsdWVzKDIsICdDYXJvbGluZScsIDEsIDMpOwoKICAgIFNFTEVDVCBscy5uYW1lLCBzMS5nZW11ZXNlIEFTIGdlbXVlc2UxLCBzMi5nZW11ZXNlIEFTIGdlbXVlc2UyCiAgICBGUk9NIGxpZWJsaW5nc3NvcnRlbiBscwogICAgSU5ORVIgSk9JTiBzb3J0ZW4gczEgT04gbHMuYSA9IHMxLnNvcnRlbmlkCiAgICBJTk5FUiBKT0lOIHNvcnRlbiBzMiBPTiBscy5iID0gczIuc29ydGVuaWQ7