return ename and dname from emp and dept tables [Resolved]

SELECT Emp.EmpName,Dept.DeptName

FROM Employee AS Emp

INNER JOIN Department Dept

    ON Emp.DeptId = Dept.DeptId

Thanks
Tanuja
(If this content helped you, Please mark it as Answer)

SELECT E.FIRST_NAME, D.Name FROM EMPLOYEE E JOIN DEPARTMENT D ON E.DEPARTMENT_ID = D.Department_ID



Explanation: Join two tables Employee and Department on the department_id column, filter the columns which you want.

Awesome Coding !! :)

Thanks & Regards
Hari