INNER JOIN

select * from Employee

select * from Department1

Select Employee.empid,Employee.empnumber,Employee.empfirstname,Employee.emplastname,
Employee.empemail,Employee.dateofjoin,Department1.deptname,Department1.Departmentid from Employee
INNER JOIN department1 on employee.departmentid=department1.departmentid 

 

Select Employee.empid,Employee.empnumber,Employee.empfirstname,Employee.emplastname,
Employee.empemail,Employee.dateofjoin,Department1.deptname,Department1.Departmentid from Employee
INNER JOIN department1 on employee.departmentid=department1.departmentid Where Department1.Departmentid=10