Re: LEFT JOIN - loosing a line from LEFT table selection
Posted by:
Rick James
Date: April 29, 2014 09:40AM
If you had a column `ParentItem` in ItemsDB, you could get rid of the extra table, and simplify the query. (You could use NULL or 0 to indicate the "top" item, which has no 'parent'.)
Doing that might mysteriously make the 'bug' go away.
Subject
Written By
Posted
Re: LEFT JOIN - loosing a line from LEFT table selection
April 29, 2014 09:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.