I have 4 tables i.e company_profile,company_people,area_of_work,area_of_practice.And out of that 3 tables have primary key which is company_id.The 3 tables are company_profile,company_people,area_of_work.4th table which is area_of_practice has common or matching field with area_of_work table which is practice_id.
I want to create join to get results from all the four tables.
Can anyone can help me.
Thanks in advance.
Lovinguy
Bookmarks