見如下兩SQL：
select sys_navigation_param_tb.*,
case when sys_navigation_param_tb.id in
(select sys_role_rihgts_tb.nav_param_id from sys_role_rihgts_tb where sys_role_rihgts_tb.role_id='1')
then 0
else 1 end flag
from sys_navigation_param_tb

select
case when (select count(id) from sys_role_rigths_tb) > 0 then sys_navigation_param_tb.group_name
else sys_navigation_param_tb.order_name
end
from sys_navigation_param_tb



---------------------------------------------------------------------------------------------------------------------------------
說人之短，乃護(hù)己之短。夸己之長，乃忌人之長。皆由存心不厚，識量太狹耳。能去此弊，可以進(jìn)德，可以遠(yuǎn)怨。
http://www.tkk7.com/szhswl
------------------------------------------------------------------------------------------------------ ----------------- ---------