见如下两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



---------------------------------------------------------------------------------------------------------------------------------
说人之短，乃护己之短。夸己之长，乃忌人之长。皆由存心不厚，识量太狭耳。能去此弊，可以进德，可以远怨。
http://www.blogjava.net/szhswl
------------------------------------------------------------------------------------------------------ ----------------- ---------