Hello,
can you please help me to see what's wrong?

INSERT INTO jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) select customerID from Customer where CustomerID =?"

i have two table linked by a foreign key, however I don't know how to insert data :(

Is this a Java question? You may be in the wrong forum. Try the databases forum

I am implementing the program in java I am also using mysql(in netbeans)

which still doesn't make it java, this is an sql matter.

jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) select customerID from Customer where CustomerID =?"

seems to me you have two sql statements and try to run them as one.