I need to combine two tables in order to get the values. As an example we have three tables having namely usertable,job table and jobaccess table. In usertable (Userid,Empid,name,Role) details have been stored. In the Job table (Jobid,Jobname,Location) details have been stored.In the Jobaccess table (userid,jobid) has been stored.
- - Job table-
Jobid JobName Location 1 Job1 Chennai 2 Job2 Chennai 3 Job3 Manila
Now using this how can get the employee name having access to the jobs. I need to have inner join in order to get the user_id. Please help me on this.