I would appreciate a little advice on the best way to develop an application.
I have a number of tables for different job roles which relate to a person table.
Each person can have numerous job roles.
My problem is whether to use my application to search each individual table where a person may have a job role.
Or would it be better to join the tables and look for the job roles within MySQL.
I know I could do this within my application but I'm sure it would be much easier within MySQL but I cannot work out how.
I have a number of tables for different job roles which relate to a person table.
Each person can have numerous job roles.
My problem is whether to use my application to search each individual table where a person may have a job role.
Or would it be better to join the tables and look for the job roles within MySQL.
I know I could do this within my application but I'm sure it would be much easier within MySQL but I cannot work out how.