import sqlite3

con = sqlite3.connect(":memory:")
c = con.cursor()

c.execute("create table jjo_errors (id integer primary key, name varchar(100))")
c.execute("create table tasks (id integer primary key, name varchar(100))")
c.execute("""create table connections_to_jjos (
    connections_id integer,
    jjo_error_id integer,
    binder_task_id integer)""")

c.execute("insert into jjo_errors values (1, 'known'), (2, '--Unknown--')")
c.execute("insert into tasks values (3, 'DCDD'), (4, 'ANDD')")

q = """
INSERT INTO connections_to_jjos(
    connections_id,
    jjo_error_id,
    binder_task_id
)
VALUES

(
    55,
    (select id from jjo_errors where name = "--Unknown--"),
    (select id from tasks where name = "DCDD")
)
,

(
    55,
    (select id from jjo_errors where name = "--Unknown--"),
    (select id from tasks where name = "ANDD")
)
"""
c.execute(q)
c.execute('select * from connections_to_jjos')
print(c.fetchall())

c.execute("insert into jjo_errors values (5, 'known'), (6, '--Unknown--')")
c.execute("insert into tasks values (7, 'something'), (8, 'ANDD')")

c.execute(q)
c.execute('select * from connections_to_jjos')
print(c.fetchall())


"""
everyting ok using:
Python 2.7.4 - sqlite3.sqlite_version '3.7.15.2'
Python 3.3.1 - sqlite3.version '2.6.0'
"""