You have an error in your SQL syntax!

[london-G]

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 =?"

[london-G]

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

[JamesCherrill]

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

[london-G]

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

[stultuske]

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.