create table report(
acode,
bcode,
ccode,
.,
.
)
create table code (
xcode
codestr,
.
)
---------------------------------------------------------
select acode from report a, code x where a.acode=x.xcode
select acode from report a, code x where a.bcode=x.xcode
select acode from report a, code x where a.ccode=x.xcode
---------------------------------------------------------
select aa.acode, aa.astr, bb.bcode, bb.codestr as bstr from (
select acode, x.codestr as astr
select acode from report a, code x
where a.acode = x.xcode
)aa, x.code bb
where aa.bcode=bb.xcode
.
.
.
이렇게 해야 하는건가요..
좀 편하게 할수 있는 방법이 있을런지요..
조언좀 부탁 드릴께요
|