Join In-DB Tool - only need the right output

Question

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.

Join Question.jpg

alexnajm · Accepted Answer

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!