select (select count(*) from system.nsuserauthority b where a.Client_No = b.OwnerID) as IsChoose,
a.Client_No,a.Client_Name from system.tClient_ID a where a.Client_Type = '3'把第一个字段转化为布尔型
a.Client_No,a.Client_Name from system.tClient_ID a where a.Client_Type = '3'把第一个字段转化为布尔型
case when ischoose='1' then true
else false
end
else false
end