I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set)
I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox.
INSERT INTO jobs (priority, date, deadline, material, status) VALUES (?, ?,?,?,? ) select customerID from Customer where CustomerID =?"
But still get an error.
Can you guys give me a hint, that will be appreciated.
PS: I am using java and mysql if this can help.