怎样创建视图?
发布时间:2017-01-02 08:23 所属栏目:52 来源:IT168 服务器频道
导读:怎样创建视图? 实现方法如下: CREATE OR REPLACE VIEW ROYAL_MDVIEW AS SELECT T1.RM_STR_FIELD AS F1, T2.RD_STR_FIELD AS F2 FROM ROYAL_MTABLE T1, ROYAL_DTABLE T2 WHERE T1.RM_INT_FIELD = T2.RM_INT_FIELD
【问】怎样创建视图? 【答】实现方法如下: CREATE OR REPLACE VIEW ROYAL_MDVIEW AS SELECT T1.RM_STR_FIELD AS F1, T2.RD_STR_FIELD AS F2 FROM ROYAL_MTABLE T1, ROYAL_DTABLE T2 WHERE T1.RM_INT_FIELD = T2.RM_INT_FIELD (编辑:ASP站长网) |
相关内容
网友评论
推荐文章
热点阅读