Exclusive Left Join Online

Doing an Exlusive Left Join Between Two Lists or Tables Online

If you want to get items or rows in one list that don't exist in another list, you need to perform an "Exclusive Left Join". This will get the values that are in list A but don't have values in list B.

This will get the unqiue values in the left dataset as per the figure above.

Example:

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

You can even 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_2.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 second foreign key as null in your where clause to insure no common keys are present.

Exclusive Left 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_2.KEY IS NULL

Exclusive Left 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_2.KEY IS NULL