Join In-DB Tool - only need the right output

[IMSL]

Hi all,

Is there anyway to only get the data from the right table when joining two tables?

I need this as I have two tables (lets say table A and B). There are some records available in both tables.

I want to remove those records from table B and only keep the remaining.

[alexnajm · Accepted solution]

You can Right Outer Join in the Join In-DB tool, then Filter In-DB after where you specify any of the new columns (i.e. any of the columns from Table B) as being not null!