> > >

MySQL MCQs

Assume, you have two tables company (id int, name text) and employee(id int, company int, name text). How would you select all employee names and their corresponding company names, e.g. John, Microsoft Mary, IBM Jane, Oracle

select employee_name, company_name from employee and company

select e.name, c.name from employee e left join company c

This is not possible

select e.name, c.name from employee e left join company c on c.id = e.company

select e.name, c.name from employee e, company c

Answer

Correct Answer: select e.name, c.name from employee e left join company c on c.id = e.company

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it