A表:party_id,id_type_cd,id_number,job_code
B表: party_id,party_type_cd
party_type_cd = '01' 为个人客户
C表: party_id,id_type_cd,id_numbera表为公司联系人表;b表为客户主表,表中party_type_cd = '01' 为个人客户;c表为证件信息表
先从A,B表找出job_code='201'的id_type_cd,id_number
再从B,C表中根据party_type_cd = '01'得出该部分的id_type_cd,id_number
把上面2个步骤得出的id_type_cd,id_number比较,相同的话则插入新表
要求用外连接,最好用一个SECLECT就搞定
B表: party_id,party_type_cd
party_type_cd = '01' 为个人客户
C表: party_id,id_type_cd,id_numbera表为公司联系人表;b表为客户主表,表中party_type_cd = '01' 为个人客户;c表为证件信息表
先从A,B表找出job_code='201'的id_type_cd,id_number
再从B,C表中根据party_type_cd = '01'得出该部分的id_type_cd,id_number
把上面2个步骤得出的id_type_cd,id_number比较,相同的话则插入新表
要求用外连接,最好用一个SECLECT就搞定
party_type_cd = 01
party_type_cd = 01
from a,b,c
where a.job_title_code = '201 ' and a.party_id = b.party_id
left outer join c on a.id_type_cd = c.id_type_cd
and a.id_number =c.id_number
and b.party_id = c.party_id
and c.party_type_cd = '01 ';
这样好像行不通阿
lz还是每个表放几条数据,然后写出自己想要的结果