create view.sql

来自「制作报表和报表模版代码 制作报表和报表模版代码」· SQL 代码 · 共 9 行

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