Home » SQL & PL/SQL » SQL & PL/SQL » Different Equals !!! (windows XP SP3 / oracle DB 10g / Forms both 6i & 10g)
icon4.gif  Different Equals !!! [message #409172] Fri, 19 June 2009 16:52 Go to next message
Hany Freedom
Messages: 256
Registered: May 2007
Location: Egypt
Senior Member

have a look for this code :-

http://img40.imageshack.us/img40/1856/mgrm.png

I'm not understanding the point from the changing of the results due to differ of equals between employee_id and manager_id !!!

any explanation ?!
Re: Different Equals !!! [message #409173 is a reply to message #409172] Fri, 19 June 2009 16:57 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Have a look at the WHERE clause. That is still on the e. table.

Re: Different Equals !!! [message #409176 is a reply to message #409173] Fri, 19 June 2009 17:53 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Add e.manager_id to the SELECT clause - that should make it clear.

Ross Leishman
Previous Topic: function
Next Topic: How to Document PL/SQL Code
Goto Forum:
  


Current Time: Tue Dec 06 12:34:37 CST 2016

Total time taken to generate the page: 0.12266 seconds