Try this:
SELECT company_profile.Company_ID, company_profile.Firstname,
Company_people.state, Company_people.city,
Area_of_Work.Practice_ID, Area_of_Practice.Category
FROM (company_profile INNER JOIN Company_people
ON company_profile.Company_ID = Company_people.company_id)
INNER JOIN (Area_of_Practice INNER JOIN Area_of_Work
ON Area_of_Practice.Practice_ID = Area_of_Work.Practice_ID)
ON company_profile.Company_ID = Area_of_Work.Company_id;
BTW: In the first table, company_profile, you have two fields with the same name--Company_ID. That won't work. Also, you indicated that you wanted the Practice_ID from the people table. I assumed you meant the Area of Work table as it is not listed in the People table.
Alan
Bookmarks