Search Field

[#1]

Hi

I have a Field with the values 1 and 2. They are for the DB1 and DB2. These two DB should be the same.

Now I would like to filter them. It should show me all values whiche are in DB2 and not in DB1.

[#2]

Hi,

  While loading your data you can use where not exists () function in your load statement.Hope this will help

Load *,

        DB As DB1

From My_table;

Load *,

      DB As DB2

From My_table1

Where not exists(DB,DB1)