|
1
|
CADYOMIKOMI?e?[?u??????????A?x?????????MTU?t?@?C???????e?[?u??????????????B
|
|
2
|
??SQL1(?????A?????A???A?????A???????):
|
|
3
|
SELECT B.meisai_no ,A.suuyou
|
|
4
|
,D.hinmei ,A.new_bui_cd ,B.new_bui_cd
|
|
5
|
FROM CADYOMIKOMI as A
|
|
6
|
inner join m_ss_meisai_cad_data as B
|
|
7
|
on A.cad_size_height =B.cad_size_height
|
|
8
|
and A.cad_size_long =B.cad_size_long
|
|
9
|
and A.cad_size_width =B.cad_size_width
|
|
10
|
and A.cad_toukyuu_cd =B.cad_toukyuu_cd
|
|
11
|
and A.cad_zaisyu_cd =B.cad_zaisyu_cd
|
|
12
|
inner join m_ss_meisai D
|
|
13
|
on B.meisai_no =D.meisai_no
|
|
14
|
??SQL2(?????A?????A???A?????A???A?V????R?[?h?????):
|
|
15
|
SELECT B.meisai_no ,A.suuyou
|
|
16
|
,D.hinmei ,A.new_bui_cd ,B.new_bui_cd
|
|
17
|
FROM CADYOMIKOMI as A
|
|
18
|
inner join m_ss_meisai_cad_data as B
|
|
19
|
on A.cad_size_height =B.cad_size_height
|
|
20
|
and A.cad_size_long =B.cad_size_long
|
|
21
|
and A.cad_size_width =B.cad_size_width
|
|
22
|
and A.cad_toukyuu_cd =B.cad_toukyuu_cd
|
|
23
|
and A.cad_zaisyu_cd =B.cad_zaisyu_cd
|
|
24
|
and A.new_bui_cd =B.new_bui_cd
|
|
25
|
inner join m_ss_meisai D
|
|
26
|
on B.meisai_no =D.meisai_no
|