27,579
社区成员
发帖
与我相关
我的任务
分享
create view(adminId,adminName,authNo,authName,isHave)
as
select
adminId,
adminName,
authNo,
authName,
isHave=case when isHave is null then 0 else 1 end
from
(
select a.*,b.adminId as isHave
from(select * from Administrator,Authority) a
left join Access b on a.adminId=b.adminId and a.authNo=b.authNo
) t
go
create view(adminId,adminName,authNo,authName,isHave)
as
select adminId, adminName, authNo, authName,
IsHave = CASE WHEN EXISTS(SELECT * FROM Access
WHERE A.adminId = adminId AND B.authNo = AuthNo)
THEN 1 ELSE 0 END
from Administrator AS A cross join Authority AS B;