TA |
|
|
|
|
TB |
|
|
Date |
WA |
WB |
WC |
|
Date |
GroupCode |
WorkCode |
20060301 |
3 |
9 |
9 |
|
20030301 |
GA |
WA |
20060302 |
4 |
10 |
10 |
|
20030301 |
GB |
WB |
20060303 |
5 |
11 |
11 |
|
20030301 |
GC |
WC |
20060304 |
6 |
12 |
12 |
|
20030301 |
GD |
- |
20060305 |
7 |
13 |
13 |
|
20030302 |
GA |
WC |
20060306 |
8 |
14 |
14 |
|
20030302 |
GB |
WA |
20060307 |
9 |
15 |
15 |
|
20030302 |
GC |
WB |
20060308 |
10 |
16 |
16 |
|
20030302 |
GD |
- |
20060309 |
11 |
17 |
17 |
|
20030303 |
GA |
- |
20060310 |
12 |
18 |
18 |
|
20030303 |
GB |
WA |
20060311 |
13 |
19 |
19 |
|
20030303 |
GC |
WB |
20060312 |
14 |
20 |
20 |
|
20030303 |
GD |
WC |
20060313 |
15 |
21 |
21 |
|
20030304 |
GA |
WC |
20060314 |
16 |
22 |
22 |
|
20030304 |
GB |
- |
20060315 |
17 |
23 |
23 |
|
20030304 |
GC |
WB |
20060316 |
18 |
3 |
3 |
|
20030304 |
GD |
WA |
20060317 |
19 |
4 |
4 |
|
20030305 |
GA |
WC |
20060318 |
20 |
5 |
5 |
|
20030305 |
GB |
WA |
20060319 |
21 |
6 |
6 |
|
20030305 |
GC |
WB |
20060320 |
22 |
7 |
7 |
|
20030305 |
GD |
- |
20060321 |
23 |
8 |
8 |
|
20030306 |
GA |
WC |
20060322 |
24 |
9 |
9 |
|
20030306 |
GB |
WA |
20060323 |
25 |
10 |
10 |
|
20030306 |
GC |
WB |
20060324 |
26 |
11 |
11 |
|
20030306 |
GD |
- |
20060325 |
27 |
12 |
12 |
|
20030307 |
GA |
WC |
20060326 |
28 |
13 |
13 |
|
20030307 |
GB |
WA |
20060327 |
29 |
14 |
14 |
|
20030307 |
GC |
WB |
20060328 |
30 |
15 |
15 |
|
20030307 |
GD |
- |
20060329 |
31 |
16 |
27 |
|
20030308 |
GA |
WC |
20060330 |
32 |
17 |
28 |
|
20030308 |
GB |
WA |
20060331 |
33 |
18 |
28 |
|
20030308 |
GC |
WB |
|
|
|
|
|
20030308 |
GD |
- |
CREATE TABLE TA
(CDATE char(8),
WA int,
WB int,
WC int
)
CREATE TABLE TB
(CDATE char(8),
GCODE char(2),
WCODE char(2)
)
두개 표에서 아래와 같은 결과를 쿼리해야 합니다.
고수님들 부탁좀 드릴께요.
DBMS는 DB2입니다.
Result Table |
|
|
|
Date |
GA |
GB |
GC |
GD |
20060301 |
3 |
9 |
9 |
- |
20060302 |
10 |
4 |
10 |
- |
20060303 |
- |
5 |
11 |
11 |
20060304 |
12 |
- |
12 |
6 |
20060305 |
13 |
7 |
13 |
- |
20060306 |
14 |
8 |
14 |
- |
20060307 |
15 |
9 |
15 |
- |
20060308 |
16 |
10 |
16 |
- |
|