|
View previous topic :: View next topic
|
| Author |
Message |
kumar1234
New User
Joined: 06 Nov 2007
Posts: 84
Location: bangalore
|
|
|
|
Hi,
Can anyone let me know the query for the below mentioned details,
Examine the details in the EMPLOYEES and DEPARTMENTS tables.
EMPLOYEES
LAST_Name Dept _id, sallary
Getz 10 10000
Davis 20 20000
King 20 20232
Davis 30 71611
Kochhar 30 17181
DEPARTMENTS
DEPARTMENT_ID DEPARTMENT_NAME
10 Sales
20 Marketing
30 Accounts
40 Administration
Write a SQL query to retrieve all employees (with the department names if applicable), whether or not they have matching departments in the departments
table.
Output will contain these columns
LAST_Name and DEPARTMENT_Name
Thanks. |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hello Kumar,
You can use below query to acheive it
| Code: |
SELECT LAST_NAME
, DEPARTMENT_NAME
FROM EMPLOYEE E LEFT OUTER JOIN DEPARTMENT D
ON E.DEPT_ID= D.DEPARTMENT_ID |
; |
|
| Back to top |
|
|
|
|
