[nimesh]

then you have to modify the query this way

Let us spit this query into parts. And check the statements carefully to understand.

First From Table1 bring results that maches to "Finance Manager"
Select * from table1 where Text like '%Finance Manager%'

Then From Table2 bring results that maches to "Finance Manager"
Here the table is changing not the criteria
Select * from table2 where Text like '%Finance Manager%'

Then From Table1 bring results that maches to "Finance" or "Manager"
Select * from table1 where Text like '%Finance%' OR Text like '%Manager%'

Then From Table2 bring results that maches to "Finance" or "Manager"
Again only the table is changing
Select * from table2 where Text like '%Finance%' OR Text like '%Manager%'

Then Bring all these data together.
Use UNION statement to join two results. But this will work only if the no of columns in both the results being joined are equal

So the Final Solution would be as below:

SELECT * FROM table1 WHERE Text LIKE '%Finance Manager%'
UNION
SELECT * FROM table2 WHERE Text LIKE '%Finance Manager%'
UNION
SELECT * FROM table1 WHERE Text LIKE '%Finance%' OR Text LIKE '%Manager%'
UNION
SELECT * FROM table2 WHERE Text LIKE '%Finance%' OR Text LIKE '%Manager%'