SQL Server :: Joins - Returns A Row When There Is Matching Table In Both Tables

Inner Join:- Returns a row when there is matching table in both tables. we can use comparison operator like =,<,>,<>

I created two tables

TableA


ID OID Type

1 1 A
2 6 B
3 7 C
4 10 D

TableB

ID Value
1 10
2 30
3 40
5 60
6 70

Basic Inner Join select Type From TableB as a inner join TableA as b on a.ID=b.OID Result Type

A
B

If i want only the type which has not match in tableB then i can use not in subquery i get the result if i m using select Type From TableB as a inner join TableA as b on a.ID<>b.OID then i get

Type
A
A
A
A
B
B
B
B
C
C
C
C
C
D
D
D
D
D

18 rows affetected i m suprise