Need some help comparing rows from 2 tables

Hello,

i have 2 tables... table 1 has sequential serial #s (a) and corresponding prices (b). table 2 has the same serial numbers (a) (used multiple times in random order). i want to put the corresponding price for each serial number from table 1 into a blank row (B) in table 2 for each row so the end result is table 3.
.
table 1 is constant and a lot shorter then table 2. i have many different "table 2s" throughout the year
.
table 1......................................table 2..................................table 3 - .....this is the result
A.......B ...................................A.........B................................A........B......i want from the
1.......5.99.................................4..........................................4........4.35.... two tables
2.......7.00.................................1..........................................1........5.99
3.......8.96.................................2..........................................2 ...... 7.00
4.......4.35.................................5..........................................5........5.45
5.......5.45.................................5 .........................................5 .......34.75
7.......15.99...............................3..........................................3....... 8.96
8.......2.50.................................9..........................................9 .......13.00
9.......13.00...............................4..........................................4 ......4.35


any help would be greatly appreciated. this is for my job and im expected to figure out a way to get it done.