|
#258. Examine the structure of the EMPLOYEES and DEPARTMENTS tables:
EMPLOYEES EMPLOYEE_ID NUMBER
DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
LAST_NAME VARCHAR2(25) DEPARTMENTS DEPARTMENT_ID NUMBER
MANAGER_ID NUMBER
DEPARTMENT_NAME VARCHAR2(35)
LOCATION_ID NUMBER You want to create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.043
Forum
Master braindump