create flag

[#1]

Hello Viewers,

There are 2 tables

In 1st table contains 10 records(emp id)

Now I have loaded 2nd table contains 25 records(emp id)

Now I want to create a flag in 2nd table with

Exists(If already exists in 1st table) and

new(If it is new record)

How to accomplish this ????

Please help!!!

[sunny_talwar]

I am pretty sure it is the other way around.

[sdmech81]

Yes definitely..Else hw can we load field which is still nt loaded.

Thanks bro:)