Everyone a great god, and new problems: the doubts about the query-CodePudding

Title:
List all staff number, name and department name;

The statement I wrote:
The select empno, ename from emp e, dname from dept d, where e.j ob='CLERK' and e.d eptno=d.d eptno;

Under the system tip: in the words of the where a * symbol, tip ORA - 00903: the table name is invalid

There is an error in statement? Logic thinking, feeling, no problem! Request advice, thank you!!!!!

CodePudding user response:

Not two the from,,,, the select empno, ename, dname from emp where d dept e.j ob='CLERK' and e.d eptno=d.d eptno;

CodePudding user response:

Thank god, thank you very much!!!!!!!!!!

CodePudding user response:

 SELECT empno, ename FROM emp e, dept d 
WHERE e.j ob='CLERK' AND e.d eptno=d.d eptno;