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

krishna ch

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

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

You can write query using the IfExits like

if exists(select 1 from tableA where EMPID = 4)

BEGIN

select * from tableA where EMPID = 4

END

ELSE

select * from tableB where EMPID = 4

END