Master data on dependent basis from 2nd Query

See more:

SQL

I have two tables Tbl1 and tbl2, Tbl1 is master table and Tbl2 is support table. We need to fetch data from from Tbl1 with multiple SQL functions like (Contains, Like,..) on the behalf of Tbl2.

I am getting ordering only from Tbl2 to get the data from Tbl1.

1     Like
2     Contains
3     etc

Accroding to Tbl2 return, I need to perform query from Tbl 1. If I have "Like" first and "Contains" in 2nd. So my Query would be

Select * from Tbl1 where columnname   Like '%keyword%'
Union
Select * from Tbl1 where Contains( Columnname, '%keyword%')
Union
Select * from Tbl1 where etc....

If we make change column order in Tbl2 then Tbl1 should be change

1     Contains
2     Like
3     etc

Tbl1 Output -

Select * from Tbl1 where Contains( Columnname, '%keyword%')
Union
Select * from Tbl1 where columnname   Like '%keyword%'
Union
Select * from Tbl1 where etc....

Can anyone help me to write such types of query.