Within my database, I have three tables: skill, job_post, and experience. My task involves joining these tables together.
Firstly, the job_post table is structured as shown here:
https://i.stack.imgur.com/lySaZ.png
The layout of the Skill table is as follows:
https://i.stack.imgur.com/r2h3S.png
Lastly, the Experience table appears like this:
https://i.stack.imgur.com/PAKED.png
My goal now is to join all of the above tables. Initially, I am joining the job_post and experience tables using the following query:
"select * from job_post as jp
join experience as e on e.exp_id = jp.exp_id
where jp.emp_id in (".$ids.")"
However, since multiple skill_ids are included in the job_post table, I am faced with the challenge of joining the job_post table to the skill table.
Note: To tackle this issue, I initially wrote the above join query, followed by creating a foreach loop to extract the skill ids from the job_post table. Subsequently, I wrote a query to match these skill ids with the skill table and display the skills.
Despite this approach, I am curious if there is a more concise way to achieve this through a single query instead of the workaround mentioned above?