见如下两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
------------------------------------------------------------------------------------------------------ ----------------- ---------
posted on 2007-12-04 14:39
宋针还 阅读(206)
评论(0) 编辑 收藏 所属分类:
SQL