서버에서
select
a.reader_cd,
a.book_cd,
a.reader_cd1,
a.reader_nm,
a.industry_cd,
a.companay,
a.school,
a.school1,
a.give_nm,
a.give_print,
a.position,
a.tel,
a.tel1,
a.hp,
a.tel2,
a.tel3,
a.dou,
a.send,
a.area,
a.zip,
a.addr,
a.addr1,
a.addr2,
a.addr3,
a.zip1,
a.addr4,
a.addr5,
a.addr6,
a.addr7,
a.expand_gu,
a.receive,
a.exp_dt,
a.exp_dt1,
a.su,
a.wol,
a.ho,
a.ho1,
a.bonus,
a.bonus1,
a.bonus2,
a.buis,
a.delivery,
a.station,
a.amount,
a.su_amount,
a.su_year,
a.memo,
a.memo1,
a.input,
a.post,
a.post1,
a.post2,
a.give,
a.giro,
a.giro1,
a.gironm,
a.jobcode,
a.dwelling,
a.sex,
a.income,
a.addr8,
a.totreader_cd,
a.gift_nm,
a.gift1_nm,
a.gift2_nm,
a.gift_cd,
a.card_cd,
a.bonbu,
a.oldcust,
a.newcust,
b.codenm book_nm,
c.codenm school_nm,
d.codenm supply_nm,
e.codenm bonus1_nm,
f.codenm bonus2_nm,
g.codenm sawon1_nm,
H.codenm sawon2_nm,
i.codenm industry_nm,
j.codenm dwelling_nm,
k.codenm sex_nm,
l.codenm income_nm,
m.codenm input_nm,
n.codenm station_nm
from custor a,books b,school c,supply d,bonus1 e,bonus1 f,sawon g,sawon h,industry i,dwelling j,sex k,income l, sawon m, buseo n
where a.receive like '동아%'
and book_cd *= b.code
and industry_cd *= c.code
and expand_gu *= d.code
and bonus *= e.code
and bonus2 *= f.code
and buis *= g.code
and delivery *= h.code
and jobcode *= i.code
and dwelling *= j.code
and sex *= k.code
and income *= l.code
and input *= m.code
and station *= n.cod
이런식으로 각 코드테이블을 한번에 조회해서 뿌리는것이 좋은지
아니면 데이터만 조회해서
화면에 표시할때 서브코드들을 조회해서 뿌리는 것이 좋은지
답변을 부탁드립니다.
|