What i have:

table1
1      a
2      b
3      c

table2
1      apple      1
2      banana     1
3      orange     2
4      pear       3
5      peach      3



What i want returned from my select:

1      a apple
2      a banana
3      b orange
4      c pear
5      c peach