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()