Examine the structure of the EMPLOYEES and DEPARTMENTS tables: You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an…

The correct answer is D. SELECT e.last_name, d.department_name, d.location_id. Equijoins are also called simple joins or inner joins. Equijoin involve primary key and foreign key. Incorrect answer: A there is no join B invalid syntax C does not involve the join in the primary and foreign key

Displaying Data from Multiple Tables and Subqueries

Question

Examine the structure of the EMPLOYEES and DEPARTMENTS tables:

You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?

Exhibit

Options

ASELECT last_name, department_name, location_id FROM employees , departments ;
BSELECT employees.last_name, departments.department_name, departments.location_id
CSELECT e.last_name, d.department_name, d.location_id
DSELECT e.last_name, d.department_name, d.location_id

How the community answered

(32 responses)

A
16% (5)
B
3% (1)
C
9% (3)
D
72% (23)

Explanation

Equijoins are also called simple joins or inner joins. Equijoin involve primary key and foreign key. Incorrect answer: A there is no join B invalid syntax C does not involve the join in the primary and foreign key

Topics

#equi-join#table aliases#join conditions#multi-table query

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice