Multiple choice

Consider the following database tables

Table Name- Jo ||| |---|---| |job_ID|Designation| |101|Clerk| |102|Analyst| |103|Manager|

Table Name- Employe |||||| |---|---|---|---|---| |EMPLOYEE_ID|FIRST_NAME|LAST_NAME|job_ID|MANAGER_ID| |7271|Amit|Saxena|102|4101| |7272|Anil|Sharma|103|4102| |7273|Mohit|Rajput|101|4103|

Find the Employee's first name and last name according to their job id. Select the correct option.

  1. select First_name, Last_name from employee1 where employee1.Job_Id=job.Job_ID;

  2. select First_name, Last_name from employee1 e, job j where e.employee_Id=j.Job_ID;

  3. select First_name, Last_name from employee1 e, job j where e.Job_Id=j.Job_ID;

  4. select First_name, Last_name from employee1 e, job j where e.Manager_id=j.Job_ID;

  5. none of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This is the correct query for the desired result.

Keep practicing — related questions