where condition check a field has data or not if exist

Question

in where condition emplyee details is exist in a table eg:table1 then take data from table1 .employee data not exists then take data from another table eg:table2  .

How to do this in where condition