T1 字段:
YHMC,DAH,XHQT2 字段CBYF,DAH,IDT1内容如下:YHMC DAH XHQ A1 B1 C1
A2 B2 C2
A3 B3 C3T2 内容如下:CBYF DAH ID200904 B1 E1T3 内容如下: DAH ID B1 E1 B2 E2
B3 E3 查出来的效果如下: 让T2表中没有的查询出来
YHMC DAH XHQ CBYF ID A2 B2 C2 200904 E2 A3 B3 C3 200904 E3
YHMC,DAH,XHQT2 字段CBYF,DAH,IDT1内容如下:YHMC DAH XHQ A1 B1 C1
A2 B2 C2
A3 B3 C3T2 内容如下:CBYF DAH ID200904 B1 E1T3 内容如下: DAH ID B1 E1 B2 E2
B3 E3 查出来的效果如下: 让T2表中没有的查询出来
YHMC DAH XHQ CBYF ID A2 B2 C2 200904 E2 A3 B3 C3 200904 E3
select * from T2 where T2.DAH not in (select DAH from T1) and T2.DAH not in (select DAH from T3)
YHMC,DAH,XHQ T2 字段 CBYF,DAH,ID T1内容如下: YHMC DAH XHQ A1 B1 C1
A2 B2 C2
A3 B3 C3 T2 内容如下: CBYF DAH ID BYDS SYDS 200904 B1 E1 200 100
200904 B2 E2 210 110
200904 B3 E3 212 150T3 内容如下: DAH ID B1 E1 B2 E2
B3 E3 查出来的效果如下: 让T2表中没有的查询出来 查询条件是CBYF = 200905
YHMC DAH XHQ CBYF ID BYDS SYDS A1 B1 C1 200905 E1 0 200A2 B2 C2 200905 E2 0 210 A3 B3 C3 200905 E3 0 212不好意思,刚才没表达好
select AA.*, BB.* from
(
select A.YHMC,A.DAH,A.XHQ,B.ID from T1 a, T3 B
where a.DAH=B.DAH
) as aa
left join T2 BB on AA.DAH=BB.DAH and
AA.ID=BB.ID
) as cc
where cc.CBFY ='200905' or CC.CBFY is null
select AA.*, BB.* from
(
select A.YHMC,A.DAH,A.XHQ,B.ID from T1 a, T3 B
where a.DAH=B.DAH
) as aa
left join T2 BB on AA.DAH=BB.DAH and
AA.ID=BB.ID
) as cc
where cc.CBFY ='200905' or CC.CBFY is null==DB2 具体语句 == 其它数据库需要替换null结果函数处理
select CC.YHMC,cc.DAH,cc.XHQ,coalease(cc.CBYF,'200905') CBYF,cc.ID,coalease(cc.BYDS,'0') BYDS,cc.SYDS
from (
select AA.*, BB.* from
(
select A.YHMC,A.DAH,A.XHQ,B.ID
from T1 a, T3 B
where a.DAH=B.DAH
) as aa
left join T2 BB on AA.DAH=BB.DAH and AA.ID=BB.ID
) as cc
where cc.CBFY ='200905' or CC.CBFY is null