CREATE TABLE employee2 ( f_employeeid INTEGER NOT NULL AUTO_INCREMENT, f_department_id INTEGER NOT NULL, f_username VARCHAR(15) NOT NULL, f_password VARCHAR(15) NOT NULL, f_firstname VARCHAR(255), f_lastname VARCHAR(255), PRIMARY KEY(f_employeeid), UNIQUE (f_username), FOREIGN KEY (f_department_id) REFERENCES department(f_departmentid) ); CREATE TABLE department ( f_departmentid INTEGER NOT NULL AUTO_INCREMENT, f_departmentname VARCHAR(255), f_departmentphone VARCHAR(255), PRIMARY KEY(f_departmentid) ); SELECT * FROM employee2, department WHERE employee2.f_department_id = department.f_departmentid