Hi i have a question regarding natural joins. I experienced a strange result and have replicated it , results below:
SQL> create table emp_test (emp_id number, e_name varchar2 (20),manager_id number, col_date date);
Table created.
SQL> insert into emp_test values (1,'dave',null,null);
1 row created.
SQL> insert into emp_test values (2,'jo',null,null);
1 row created.
SQL> create table emp_test2 as select * from emp_test;
Table created.
SQL> select * from emp_test natural join emp_test2;
no rows selected
Can somebody explain why are no rows selected when the columns are the same and the data is the same?
Many thanks