**Table1**

| Short name |
| --- |
| KA |
| ERCA |
| MES |
| RNES |

**Table2**

| CustomerName |
| --- |
| Wilman Kala |
| Tradição Hipermerca |
| Hanari Carnes |
| Victuailles en stoc |
| Suprêmes délices |
| Hanari Carnes |

Now I want to fetch all the values from Table 2 by verifying individual row

EX :

```
select * from Table2 where CustomerName like '%KA%' 
UNION 
select * from Table2 where CustomerName like '%ERCA%'
UNION 
select * from Table2 where CustomerName like '%MES%'

```

and so on... I am having 16000 + rows in Table1