Shulou(Shulou.com)06/01 Report--

Two query results similar to SQL, which have not been noticed before

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

Who knows what happened? Welcome to leave a message.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.