How to find non match elements from two list of csv files and how to import csv file in SQL - SQL two tables

 > Right click on Database in SQL Server and 

> Click on Task

> Click on Import Flat file

> Select CSV file and it will be saved in table as csv file name.

Now execute query below :-

select * from Courtapp t1 full outer join Dashboard t2 on t1.test = t2.test where t2.test is null

ref:- https://stackoverflow.com/questions/4044919/opposite-of-an-inner-join-query