1.定制SQL
select cfg.DEVICENAME,cfg.TARGETIP,st.*
from "_PATROL__MEM_0_ST_VIEW" st,"_PATROL__MEM_0_CFG_VIEW" cfg
where st.MOINSTID=cfg.MOINSTID
2.结果

1.定制SQL
select cfg.DEVICENAME,cfg.TARGETIP,st.*
from "_PATROL__MEM_0_ST_VIEW" st,"_PATROL__MEM_0_CFG_VIEW" cfg
where st.MOINSTID=cfg.MOINSTID
2.结果

评论前必须登录!
注册