sql查询求助
select
tc.order_no,
tc.customer_nm_kn_sei_disp,
tc.customer_nm_kn_mei_disp,
tc.customer_nm_kj_sei,
tc.customer_nm_kj_mei,
tc.expand_address_kj1,
tc.expand_address_kj2,
tc.sub_address_kj1,
tc.sub_address_kj2,
tc.tel1,
tc.tel2,
tc.tel3,
tc.mobile_tel1,
tc.mobile_tel2,
tc.mobile_tel3,
tc.create_date,
tcr.management_date,
tcr.resend_kbn
from
TB_CUSTOMER_ATTR tc,
TB_CUSTOMER_ATTR_RESEND tcr
where
tc.delete_flg = '0' AND
tcr.resend_kbn(+) = '00' AND
tcr.delete_flg(+) = '0' AND
tc.general_account_kbn = '10' AND
tc.order_no = tcr.order_no(+)
order by tc.create_date
现在想增加一个tcr.resend_kbn(+) = '99'
本来想用union连接2个条件的,但是tc.order_no有重复怎么解决?
tc.order_no,
tc.customer_nm_kn_sei_disp,
tc.customer_nm_kn_mei_disp,
tc.customer_nm_kj_sei,
tc.customer_nm_kj_mei,
tc.expand_address_kj1,
tc.expand_address_kj2,
tc.sub_address_kj1,
tc.sub_address_kj2,
tc.tel1,
tc.tel2,
tc.tel3,
tc.mobile_tel1,
tc.mobile_tel2,
tc.mobile_tel3,
tc.create_date,
tcr.management_date,
tcr.resend_kbn
from
TB_CUSTOMER_ATTR tc,
TB_CUSTOMER_ATTR_RESEND tcr
where
tc.delete_flg = '0' AND
tcr.resend_kbn(+) = '00' AND
tcr.delete_flg(+) = '0' AND
tc.general_account_kbn = '10' AND
tc.order_no = tcr.order_no(+)
order by tc.create_date
现在想增加一个tcr.resend_kbn(+) = '99'
本来想用union连接2个条件的,但是tc.order_no有重复怎么解决?
作者: blackouts 发布时间: 2011-05-05
贴建表及插入记录的SQL,及要求结果出来看看
用DISTINCT不行?
用DISTINCT不行?
作者: WWWWA 发布时间: 2011-05-05
有重复你想怎么做,取重复的哪一条
作者: rucypli 发布时间: 2011-05-05