OK, This is what I have implemented.

If exists (select idbatch from jbjob inner join insts_temp on insts_temp.inst = jbjob.idInst and insts_temp.BusDate = jbjob.BusinessDate and jbjob.idbatch=40)

Begin

...

Thanks for your reply.

I implemented this through Delete statements after checking batch condition with if exists. It worked as expected.

Thanks!!

Sunny

Ok. Let me explain the situation for which I need solution.

I have 2 tables.

1: Pos_testing. Columns: Idinst

2: Pos. Columns: Idinst and idbatch

Now pos_testing has 3 values. 12345,123456,1234567

And pos has 5...

a