I have these 2 tables in my SCOTT schema:

EMP:

Name Null? Type
EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
MGR NUMBER(4)
HIREDATE DATE
SAL NUMBER(7,2)
COMM NUMBER(7,2)
DEPTNO NUMBER(2)


DEPT:

Name Null? Type
DEPTNO NOT NULL NUMBER(2)
DNAME VARCHAR2(14)
LOC VARCHAR2(13)

I inserted the following values:
insert into emp(empno,deptno)
values(7777,40);

Then i ran this query:
select e.ename,d.dname,d.loc
from emp e inner join dept d
on e.deptno = d.deptno
where ename <> '_%_'
order by 3;

I am getting results that have enames only but not the ones that were left empty.Why is that?
Now what is happening here exactly i want to know?

__________________
MAXOOD!

Life is an endless journey towards perfection