Using Results Of Query In A Query

Hello all,
I'm looking for some hints as to how to use the results of a query in
another query. I assume I'm 'thinking' wrong in how to solve this, so
I'm hoping someone can clobber me and send me in the right direction.

My question is best illustrated by simplified example. I have one
table (table A) with a single column called "Word". This table
contains 100 records of single words. Another table (table B)
contains whole sentences in a single column. I want to eventually
count the occurances of all of the words in Table A, in each of the
sentences in Table B and store these results in another table. Here's
the 'thinking wrong' part. The only way I can see to do this is to
select the entire table A using a cursor, then select 'LIKE's of the
result against each individual row in table B. This seems horribly
inefficient, and I know there have to be one or two MUCH better ways
to do this, but I can't get me head wrapped around thinking in SQL at
this stage. Any info appreciated.

Thanks,
Stan