Find Common Items Between Two Lists

Inner Join Between Two Lists or Tables Online

Getting common items between two lists or rows between two tables is called "Inner Join". If you want to discard all unique values in two lists you need to inner join between these lists.

This will get the common values in the center as per the figure above.

Example:

    List A      List B      Inner Join A + B
    A           A           A
    B           B           B
    C           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.

Inner Join Between Two Lists or Tables Using MSSQL

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

    SELECT * FROM TABLE_1 INNER JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.FOREIGNKEY

The foreign key in this case represents the common column between the two tables that you want the join to happen on.

Inner 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 INNER JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.FOREIGNKEY

Inner Join Between Two Tables in MySQL

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

    SELECT * FROM TABLE_1 INNER JOIN TABLE_2 ON TABLE_1.KEY = TABLE_2.FOREIGNKEY