query :

SELECT * FROM drivertest_emp e , drivertest_dept d WHERE e.empid = d.deptname