第一问答网»论坛 › 中问网 › 问答 › a sql about two table into one table please chao p ...

a sql about two table into one table please chao ping come in

11 |

0 | 2002-9-23 10:43:00 | 显示全部楼层 |阅读模式

two table ab
write a sql not a pl/sql block
table b
b1b2b3b4
20021 1 3
20022 3 6
20023 6 12
20024 1224
20025 2436
20026 3648
20027 4860
20028 6072
20029 7284
2002108496
20021196108
200212108 120
200213120 120
200214120

table a

a1a2 a3a4
122
3
244 6
386
9
423 812
4351015
4471218
4581421
464 1624
979 1827
10 86 2030
11 94 22 33
12 10624 36
13 12026 39
14 13028 42

select
a1
,c2
,a3
,a4
from
a
where
a1=4

c2's values get from table b.b2

the condition is

c2 = b2
b2
b3a2 b4
1
1 <=a2< 3
2
3 <=a2< 6
3
6 <=a2< 12
4
12<=a2< 24
5
24<=a2< 36
6
36<=a2< 48
7
48<=a2<
60
8
60<=a2<
72
9
72<=a2<
84
10
84<=a2<
96
11
96<=a2<
108
12
108 <=a2<
120
13
120=a2=
120
14
120<a2

使用道具举报

返回列表发新帖

千问

主题	0 回帖	4882万积分

论坛元老

Rank: 8 Rank: 8

积分: 48824836

回复楼主返回列表

问答

热门排行