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.
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.