Find last_name and first_name for all employees assigned to the department
CREATE TABLE ' Dept_emp ' (
' Emp_no ' int (one) is not NULL,
' Dept_no ' char (4) Not NULL,
' From_date ' date not NULL,
' To_date ' date not NULL,
PRIMARY KEY (' emp_no ', ' dept_no '));
CREATE TABLE ' Employees ' (
' Emp_no ' int (one) is not NULL,
' Birth_date ' date not NULL,
' first_name ' varchar (not NULL),
' last_name ' varchar (+) not NULL,
' Gender ' char (1) Not NULL,
' Hire_date ' date not NULL,
PRIMARY KEY (' emp_no ')); Enter a description:
No
Output Description:
last_name |
first_name |
Dept_no |
Facello |
Georgi |
d001 |
Omitted |
Omitted |
Omitted |
Piveteau |
Duangkaew |
d006 |
Select e.last_name,e.first_name,d.dept_no from Inner Join Employees e on D.emp_no=e.emp_no
Inner joins and other connection methods are described in my blog post.
SQL Find all employees who have assigned departments