[technica]

Select * from table1 where Text like '%Finance Manager%'
Union
Select * from table2 where Text like '%Finance%' OR Text like '%Manager%'


Hope this helps you