aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-02042: view or subquery in from list

QSM-02042: view or subquery in from list
Cause: The capability in question is not supported when the materialized view references a view or subquery in the FROM list.
Action: Re-phrase the query to avoid the use of views or subqueries in in the FROM list.

请先 登录 后评论

1 个回答

小智
QSM-02042:从列表中查看或子查询,
.原因:当物化视图引用FROM列表中的视图或子查询时,不支持该问题的功能。,
.操作:重新排序查询以避免在FROM列表中使用视图或子查询。,
.
请先 登录 后评论