Creating A Third Table From Two Tables

Hi All,
I will like to create a table from two tables this (explained below) way using a stored procedure. Basically i want the stored procedure to return me the third table but i dont know how to do it.
Table A
TopicID      Topic
----------------------------- 
1               Sometopic 1

2               Some topic 2

3               Some topic 3

4                Some topic 4
 
Table B
RateID     Rate     TopicID
---------------------------------------
1            5         1

2            5         1

3            5         2

4            4         2

5            4         3

6             3         5
 
Table C
TopicID     Topic             Rate
--------------------------------------------
1            Some topic1        5

2            Some topic 2      5  

3             Some topic 3      5
Basically i have a table that stores topics associated with a particular subject. Those topics are stored in table A above. My users can just read the messages associated with the topic and rate that message. The rating is then stored in table B.
Now i will like my users to search for topics with a particular word or sentence in table A and the topics that are returned have a rating they specify. My procedure takes the word or sentence to search in table A and and the rating which will be used in table B. I will like to construct another table that has this newly searched results and return it using a stored procedure or anything simple. I dont know how to do this because i have very little knowledge in stored procedures or sql.....
 
Any help(Code) will be greatly appreciated...