Hi,
I'm trying to get to grips with MySQL Databases and Tables.. I was wondering if it was possible to do the following..
Say I have 2 tables... This is a random example so dont take the design to literally..
Jobs
-----
job_id
engineer_id
job_description
job_date
Engineers
-----------
engineer_id
engineer_name
engineer_phoneno
Ok,
Well i understand that if I run the query "SELECT * FROM Jobs" that I will get the list of jobs... but is it possible to return an array that includes the engineers details in it... so the array/table returned would have...
job_id
engineer_name
engineer_phoneno
job_description
job_date
I have done something similar in the past but it involved a loop and lots of queries.. this doesnt seem right..
hope you get what i mean
I'm trying to get to grips with MySQL Databases and Tables.. I was wondering if it was possible to do the following..
Say I have 2 tables... This is a random example so dont take the design to literally..
Jobs
-----
job_id
engineer_id
job_description
job_date
Engineers
-----------
engineer_id
engineer_name
engineer_phoneno
Ok,
Well i understand that if I run the query "SELECT * FROM Jobs" that I will get the list of jobs... but is it possible to return an array that includes the engineers details in it... so the array/table returned would have...
job_id
engineer_name
engineer_phoneno
job_description
job_date
I have done something similar in the past but it involved a loop and lots of queries.. this doesnt seem right..
hope you get what i mean