How to Select unmatched data from two column in two table

With SQL Server 2012 you can use the EXCEPT keyword

USE [CentralDB]
GO

CREATE TABLE T1 ( ID INT, DName VARCHAR(20)-- column_name data_type,...
   )
CREATE TABLE T2 ( ID INT, DName VARCHAR(20)-- column_name data_type,...
   )

INSERT T1
VALUES ( 1, 'Bill' ),
 ( 3, 'Barry' ),
 ( 4, 'Bryan' ),
 ( 6, 'Bob' ),
 ( 7, 'Bert' )

INSERT T2
VALUES ( 1, 'Charles' ),
 ( 2, 'Chris' ),
 ( 3, 'Colin' ),
 ( 6, 'Clive' ),
 ( 8, 'Clint' )

( SELECT ID
  FROM T1
  EXCEPT
  SELECT ID
  FROM t2
)
UNION
( SELECT ID
  FROM T2
  EXCEPT
  SELECT ID
  FROM t1
)

DROP TABLE T1
DROP TABLE T2

To find the records in T1 that are not in T2 you can LEFT JOIN T1 to T2 and limit to where there is a NULL in the ID column of T2. Is that what you're trying to do?

SELECT *
FROM T1 
LEFT JOIN T2
    ON T1.Id = T2.Id
WHERE T2.Id IS NULL

If you need the intersection, use the INNER join. If you need the records which are in left side table and not in right side table which we can say disjunction, use the LEFT join and put the condition RIGHT TABLE.ID IS NULL in where clause. This way you can read the record which are in left side table bit not in right side table.