I dont know why I have been struggling over this the past day or so, should be realitively simple to produce, but my mind has gone totally blank. I have 3 Tables currently under a database that I am linking People with differnent "Expertise" Feilds.
The first table contains nothing but the listed Expert's profile information (id, first name, last name, phone numbers emails etc.
The second table contains nothing but the areas of Expertise: (id, expertise)
The third table will contain the linked ids of the profile and expertise areas (id, expert_id, area_id)
What I would like to do is be able to query the third table yet pull information from the 1st and 2nd table as well.
So if i was looking for someone that had an expertise in Physics I could query SELECT * from TABLE3 where area_id='3') and be able to pull all the Expert's information. The reason I want to keep these things seperate is for updating purposes. Because the Expertise Areas are not unique to the experts, or i would have included them in the same table.
To view a txt file of the structure I have been thinking about follow this link http://www.zeroedin.com/database_design.txt
It'll help you understand more what I am doing and may help you understand where I am getting stuck.
I know there's gotta be a super easy solution to this, and dont know why I'm over looking something. If anyone could help me out I would appreciate it.
Thanks!
