DATABASE Suppose I have 2 tables with ID, and Text table1 ID Text 1 Finance Manager 2 Accountant 3 Office Manager table2 ID Text 1 Sales Manager 2 Import manager 3 Finance Manager I wish to search for...

DATABASE

Suppose I have 2 tables with ID, and Text

table1


ID Text

1 Finance Manager
2 Accountant
3 Office Manager



table2


ID Text

1 Sales Manager
2 Import manager
3 Finance Manager
I wish to search for Finance Manager where the query result must bring all maches "Finance Manager" from the two tables.

Find a solution for the above query and explain why your statement is appropriate