create view.sql

制作报表和报表模版代码 制作报表和报表模版代码

create view v_nc_query_funnode as 

select f.cfunid, f.fun_code, f.fun_name, f.fun_property, f.help_name 
from  sm_funcregister f  

union all

select b.cfunid,  b.fun_code, b.fun_name, 9999, 'help_name'
from sm_butnregister b