import sqlite3
con = sqlite3.connect("../test1.db")
c = con.cursor()
sql = """select f.text, a.text
from frage f
join antwort a on f.id = a.frage_id"""
c.execute(sql)
select = c.fetchall()
print(sql)
c.close()