ORA-00942：表或视图不存在 [英] ORA-00942: table or view does not exist

问题描述

我已经创建了表格并插入了记录，但是在显示错误的连接查询中。



我尝试了什么：

i have created table and inserted record but in join query showing error.

What I have tried:

select gi.group_members as ID, em.EMP_NAME as NAME, em.EMAIL_ID as EMAIL , v.DIR_MOBILE
from groupinfo gi 
join emp_master em on gi.group_members= '3'|| EMP_NO || '0' 
join V_EMP_MOBILE v on v.DIR_EMP_NO='3'|| EMP_NO || '0'
and group_name='oper';

推荐答案

看看这个：Oracle / PLSQL：ORA-00942错误消息 [ ^ ]

您可以找到解决此问题的几个选项。

Check out this: Oracle / PLSQL: ORA-00942 Error Message[^]
There you'll find few options how to resolve this issue.

这篇关于ORA-00942：表或视图不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！