I was using the insert query when I faced a problem , I want to insert the foreign key , for example :
I want to insert the employee's ID in the job table where the employee's name is "XYZ" in the employees table,
I tried to select from the employees table the ID where the name is "XYZ" then insert it in the job table.
Is this a right way or what can I do else?
Thanks in advance.