Performing A Query Using Two Tables

Hi,

Have a database that contains various tables.

I need to run a query on two tables.

Table A contains a column called Titles

Table B contains a column called Uni_Titles

In Table B's column it contains multiple titles as shown below
separated by semi-colons in each row.


Table B Uni-Title Column
__________________________
Row 1: Landlord and tenant; Leases; Rent reviews

Row 2: Acquisitions; Advisers; Appointment; Contract term


Table A - Titles Column
_________________________
Table A's column contains a only one of the words in Table B's column

i.e. Landlord and tenant

I would like to obtain a count of how many times the same word or
phrases appears in the column of Table B.

Thanks

Steve