In my class notes for the students, I have now denonstrated how a NATURAL JOIN between EMPLOYEES and DEPARTMENTS produces the wrong results. On Feb 25, 2013 1:07 AM, "Tim Hall" <tim@xxxxxxxxxxxxxxx> wrote: > It's important that people know what a natural join is, but I don't > believe they have a place in software development. In using one you are > stating that you are happy that any future changes to the tables in > question will have no impact on your query. This can not be guaranteed. :-) > > Cheers > > Tim... > -- //www.freelists.org/webpage/oracle-l