Query on Employee

Question

Hi all i have one query with union

 

select name from employee_1

 

Union

 

select name from employee_2

 

,

 

here i want to display all employee results , if i have an employee with name ='ganesh' , if there is no such employee with name='ganesh' then dont return any result from query

 

pls help me on this