if column not exists from table A then select from tab B

Question

Hi thanks in advance

I was strucked here in c#

 

I have tables (A & B)

some customers EMPID column in table A and some are in Table B

Now I want to write select statement:   if EMPID not exists in A then choose from B.

Please guide me