You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
6 lines
354 B
SQL
6 lines
354 B
SQL
/* to display the department number, name ( first name and last name ), job and department name for all employees in the
|
|
Finance department.*/
|
|
SELECT e.department_id, e.first_name, e.job_id , d.department_name
|
|
FROM employees e , departments d
|
|
WHERE e.department_id = d.department_id
|
|
AND d.department_name = "Finance"; |