Re: How to write this sql urgent...

From: JIACHENG SUN <sunjcb_at_googlemail.com>
Date: Mon, 25 Jan 2010 08:06:15 -0800 (PST)
Message-ID: <e39f5472-8f26-47c8-9366-8a5e7fb010cb_at_21g2000yqj.googlegroups.com>

On Jan 25, 4:04 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "JIACHENG SUN" <sun..._at_googlemail.com> a crit dans le message de news:
> c56a0f25-dc7d-4325-9bc4-3415e35b9..._at_a32g2000yqm.googlegroups.com...
> | table 1
> | 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!!
>
> And the rule to generate the output is?
>
> Also provide a test case: create table and insert statements.
>
> Regards
> Michel

Hi,

thanks for your reply.

The result i want is:
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! Received on Mon Jan 25 2010 - 10:06:15 CST