The title describes the Last_Name and first_name of all employees and the corresponding department number dept_no, as well as showing employees who are not assigned a specific 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 |
Sluis |
Mary |
Null (null here in SQLite, MySQL is null) |
Select e.last_name,e.first_name,d.dept_no from Left Join dept_emp D on E.emp_no=d.emp_no;
SQL Find all Employee information (two table connection queries)