Câu 32: C2090-610: DB2 10.1 Fundamentals

Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. WhichSQL statement will produce the desired list?

1. A. SELECT employees.name, sales.revenueFROM employeesINNER JOIN sales ON employees.id = sales.emp_id
2. B. SELECT employees.name, sales.revenueFROM employeesINNER JOIN sales ON sales.emp_id = employees.id
3. C. SELECT employees.name, sales.revenueFROM salesLEFT OUTER JOIN employees ON employees.id = sales.emp_id
4. D. SELECT employees.name, sales.revenueFROM salesRIGHT OUTER JOIN employees ON employees.id = sales.emp_id — đáp án hiện tại