How to write this sql urgent...

ref     code
1       code_1
1       code_2
2       code_3
2       code_5

table 2

code      code_description    value
code_1    description1         3.4
code_2    description2         3.5
code_3    description3         0
code_4    description4         0
code_5    description5         0

how to write a sql to get the result below:

ref    code       description      value
1      code_1    description1       3.4
1      code_2    description2       3.5
1      code_3    description3       0
1      code_4    description4       0
1      code_5    description5       0
2      code_1    description1       3.4
2      code_2    description2       3.5
2      code_3    description3       0
2      code_4    description4       0
2      code_5    description5       0

thanks so much!! Received on Mon Jan 25 2010 - 08:23:55 CST