NoSal多表连接数据重复

Question

问题遇到的现象和发生背景

        SELECT e.empno,e.ename , e.sal , s.grade  ,D.loc
        FROM emp e,salgrade s,DEPT D
        WHERE sal between losal and hisal
        order by grade

结果很奇怪？

我想要达到的结果

Answer 1

你这三个表不关联吗，losal和hisal是什么意思