lets say i have 2 tables

```
ID      Product
----------------
 micrsoft sql 
 cisco 

ID      Product
----------------
sql
cisco agent
flash

```

I need to write a query that returns only 'flash' as output becasue it does not have a match on table 1. The words cisco and microsoft have matches on the other table and so needs to be discarded.

This is more of an inner join but using pattern/string match/contains. The strings needs not be an absolute match and can also be a subset . for eg. you have cisco in one table and cisco agent in the other .

/\*\*\*\*\*\* Script for SelectTopNRows command from SSMS \*\*\*\*\*\*/

```
SELECT  
      [Product] 
  FROM t1 INNER JOIN t2

ON t1.Product= t2.Product
order BY Product

```

will only satisy those products whose value exactly match . But i would need to query even partial matches