select a.rq,
a.djbh,
b.dwmc,
b.dwbh,
a.je,
a.lshje,
d.name as bm,
c.name as ywy,
e.name as username,
g.kslxr,
g.lxdh,
f.name as zbmc,
a.xgdjbh
from yw_jzhzb a,
t_dwzl b,
zl_zyzlb c,
zl_jgzlb d,
acl_user e,
zl_zbzlb f,
yw_cgdjhzb g
where a.dwid = b.dwid
and a.ywyid = c.resid
and a.bmid = d.resid
and a.createby = e.userid
and a.zbid = f.resid(+)
and a.xgdjbh = g.djbh
and a.je >= 0
and a.djbs = 'CGA'
[$jgid] [$start_rq] [$end_rq] [$dwid] [$djbh]
order by a.rq, a.djbh寻求语句对应的解释,其中:查询类容为汉子的缩写,比如日期=rq,from后面是相应的表明
a.djbh,
b.dwmc,
b.dwbh,
a.je,
a.lshje,
d.name as bm,
c.name as ywy,
e.name as username,
g.kslxr,
g.lxdh,
f.name as zbmc,
a.xgdjbh
from yw_jzhzb a,
t_dwzl b,
zl_zyzlb c,
zl_jgzlb d,
acl_user e,
zl_zbzlb f,
yw_cgdjhzb g
where a.dwid = b.dwid
and a.ywyid = c.resid
and a.bmid = d.resid
and a.createby = e.userid
and a.zbid = f.resid(+)
and a.xgdjbh = g.djbh
and a.je >= 0
and a.djbs = 'CGA'
[$jgid] [$start_rq] [$end_rq] [$dwid] [$djbh]
order by a.rq, a.djbh寻求语句对应的解释,其中:查询类容为汉子的缩写,比如日期=rq,from后面是相应的表明
不就是多表连接的关联查询嘛
where后面是连接条件和过滤条件啊
where子句里面,通过某些共有的列关联起来,限制某些表里的属性值
按某些属性排序
是条件的一部份
或者没copy完整
$jgid] [$start_rq] [$end_rq] [$dwid] [$djbh]
应当是在哪里COPY的,然后没有处理一下!
我猜是嵌入在SQL里面,有后面程序动态替换使用的key