Sorry but I am worried that I did not explain clearly so I am adding in the error message I get from Netbean IDE when I run that queries using the last solution provided.
I'm puzzled that given a perfect match - that is same subjects from parent's requirements and tutors' can teach subjects, and the same locations, it still gives me errors. Overall, I do not quite understand that query and the coding that will give me the matching display. Hope that you can kindly teach me what you have written in that codes. Many thanks.
An error occurred: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.