185 views
0 votes
0 votes

just random query so my question is that I write WHERE e.deptno = d.deptno .
OKK SO IF I WRITE INSTEAD OF THIS d.deptno.=e.deptno. THEN CAN IT EVALUATE SAME VALUE OR DIFFERENT?
AS IN SOME BIG QUESTIONS I AM DOING THIS WRONG SO HELPPP


SELECT e.ename, d.dname
FROM   emp e, dept d
WHERE  e.deptno = d.deptno
AND    e.sal > 1000;

Please log in or register to answer this question.

No related questions found