Re: How to write this sql urgent...
From: chetan <rockvedh_at_gmail.com>
Date: Tue, 26 Jan 2010 00:11:57 -0800 (PST)
Message-ID: <14a8a94d-e94e-4295-b3d0-93e731d3f43d_at_g29g2000yqe.googlegroups.com>
On Jan 25, 7:23 pm, JIACHENG SUN <sun..._at_googlemail.com> wrote:
> 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!!
Date: Tue, 26 Jan 2010 00:11:57 -0800 (PST)
Message-ID: <14a8a94d-e94e-4295-b3d0-93e731d3f43d_at_g29g2000yqe.googlegroups.com>
On Jan 25, 7:23 pm, JIACHENG SUN <sun..._at_googlemail.com> wrote:
> 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!!
SELECT * FROM (SELECT DISTINCT REF FROM TABLE1) A, TABLE2 B ORDER BY A.REF,B.CODE Received on Tue Jan 26 2010 - 02:11:57 CST