0
try this Pramod:
select e.empno,e.empname,e.department,e.designation,r.periodofleavefrom,r.perodofleaveto,r.noofdays from Employee_registration e,Restricted_leaves r where (e.empno=r.empno and e.empno='emp1')
thanks
Please mark as answere if it helps
Accepted