-
-
ts-Emma 初学数据Lv2
发表于2021-9-8 16:11
悬赏1
已解决
12个回答
sql如下,用户123456还是只查询到了 用户是123456 的数据
SELECT LIMIT 1000 * FROM (select MAX(a.bankname) as B2,MAX(a.startdate) as C2,sum(a.dkamount) as D2,MAX(a.tbrname) as E2,MAX(a.tbrphone) as F2,MAX(a.lpdate) as G2,sum(a.lpamount) as H2,sum(a.yhamount) as I2,MAX(a.identifynumber) as J2,MAX(a.czadress) as K2,MAX(a.gsxy) as L2,MAX(a.administrator) as M2,MAX(a.issw) as N2,MAX(a.issl) as O2,MAX(a.tqphone) as P2,MAX(a.isjq) as Q2,a.policyno as A2
from (select a.id,a.policyno,a.bankname,a.startdate,a.dkamount,a.tbrname,a.tbrphone,a.lpdate,a.lpamount,a.yhamount,a.identifynumber,a.czadress,a.gsxy,case when c.username is not null then c.username else a.administrator end administrator ,
case when a.issw='1' then '是' when a.issw='0' then '否' else a.issw end issw,case when a.issl='1' then '是' when a.issl='0' then '否' else a.issl end issl,a.tqphone,case when a.isjq='1' then '是' when a.isjq='0' then '否' else a.isjq end isjq
from xd_lpkh a ,outer xd_ryxx c
where a.administrator=c.usercode
) a
where (((a.administrator = '123456') and (2>1) or not (a.administrator = '123456') and (a.administrator = '123456')))
group by a.policyno)