Find Uncommon Items Between Two Lists

Exclusive Full Join Between Two Lists or Tables Online

Getting uncommon items between two lists or rows between two tables is called "Exclusive Full Join". This is when you want to get values in list A that don't exist in list B and vice versa. This can be visualized as per below graph:

Example:

    List A      List B      Exclusive Full Join
    A           A           D
    B           B           E
    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 Full Join Between Two Lists or Tables Using MSSQL

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

    SELECT * FROM TABLE_1 FULL OUTER JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.FOREIGNKEY WHERE TABLE_1.KEY IS NULL AND TABLE_2.KEY IS NULL

It's important to add the WHERE condition specifying the nullability of the common column or key in each of the tables. This is to insure that records in Table 1 do not exist in Table 2.

Exclusive Full 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 FULL OUTER JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.FOREIGNKEY WHERE TABLE_1.KEY IS NULL AND TABLE_2.KEY IS NULL

Exclusive Full Join Between Two Tables in MySQL

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

        SELECT * FROM TABLE_1 FULL OUTER JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.FOREIGNKEY WHERE TABLE_1.KEY IS NULL AND TABLE_2.KEY IS NULL