select afa050, , afb010, afb002, afb003
from syn_fs_fb27 a
where 1 = 1
<isNotEmpty prepend=" And " property="afa050">
a.afa050= $afa050$
</isNotEmpty>
<isNotEmpty prepend=" And " property="fpzdm">
a.fpzdm = $fpzdm$
</isNotEmpty>
<isNotEmpty prepend=" And " property="afb010">
TO_CHAR(a.afb010) = $afb010$
</isNotEmpty>
and not exists (select * from V_TRANS_FB57
where afa050 = a.fdwdm
and afb010 = a.afb010
and afb002 = a.afb002
and afb003 = a.afb003
<!-- 表示该票段的票已全部用完 -->
and afb572 = '2')
from syn_fs_fb27 a
where 1 = 1
<isNotEmpty prepend=" And " property="afa050">
a.afa050= $afa050$
</isNotEmpty>
<isNotEmpty prepend=" And " property="fpzdm">
a.fpzdm = $fpzdm$
</isNotEmpty>
<isNotEmpty prepend=" And " property="afb010">
TO_CHAR(a.afb010) = $afb010$
</isNotEmpty>
and not exists (select * from V_TRANS_FB57
where afa050 = a.fdwdm
and afb010 = a.afb010
and afb002 = a.afb002
and afb003 = a.afb003
<!-- 表示该票段的票已全部用完 -->
and afb572 = '2')
from syn_fs_fb27 a 这个SQL多个逗号吧