12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
mysql数据库 时间：2024-12-25 09:55:12
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
两个相似SQL的查询结果，以前未曾注意
select a.*, case when x.resno is null then 0 else 1 end as isown from prm_res aleft join(select b.resno from prm_res binner j
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
两个相似SQL的查询结果，以前未曾注意
select a.*, case when x.resno is null then 0 else 1 end as isown from prm_res a
left join
(select b.resno from prm_res b
inner join prmg_role_res c on b.resno=c.resno
inner join prmg_acct_role d on d.roleno=c.roleno and d.acct=1
) as x
on a.resno=x.resno where a.sysno=1;
select a.*, case when x.resno is null then 0 else 1 end as isown from prm_res a
left join
(select b.resno from prm_res b
inner join prmg_role_res c on b.resno=c.resno
inner join prmg_acct_role d on d.roleno=c.roleno and d.acct=1
) as x
on a.resno=x.resno and a.sysno=1;
谁知道啥情况？欢迎留言
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19