Exclusive Right join

Exclusive Right Join Between Two Lists or Tables Online

This is similar to running an exclusive left join but in reverse. This will get the values that are in list B but don't have values in list A.

This will get the unique values in list B that don't exist in list A.

Example:

    List A      List B      Exclusive Right Join
    A           A           E
    B           B           
    C           C           
    D           E

To do this using the free online tool, just copy the first list values in the first editor, the second list values in the middle editor and click on convert.

You have the option to surround the output with any character using the output settings, and even sort them in ascending or descending order.

Exclusive Right Join Between Two Lists or Tables Using MSSQL

You can even perform an exclusive right join between two lists or tables in microsoft SQL server similar to the below code example:

    SELECT * FROM TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.KEY AND TABLE_1.KEY IS NULL

The WHERE statement here is important as this will insure that there are no common values between TABLE_1 and TABLE_2. So you will need to set the first key as null in your where clause to insure no common keys are present.

Exclusive Right Join Between Two Table Using Oracle

This is similar to any database querying example, you can join between two tables in oracle like the below example:

    SELECT * FROM TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.KEY AND TABLE_1.KEY IS NULL

Exclusive Right Join Between Two Tables in MySQL

This is how you can join between two tables in MySQL, It is also similar to MSSQL as well as Oracle querying:

    SELECT * FROM TABLE_1 LEFT JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.KEY AND TABLE_1.KEY IS NULL