Outer Join with Tibero v6

I consider a specific example where we have a parent-child relationship. For example, when we build a menu for an application, we have the individual Menu Items. However, each Menu Item will have a Parent Menu Item. At the Root Level, we will have a set of Menu Items, whose parent will be the Root Menu Item.

The same example applies where we consider the directory structure on a disk. Like in the case of the Menu, we do not know till how many levels the directories may be nested.

For either of these example, we can consider a data structure as shown below.

Here, PARENT_NODULE is also a MODULE_CODE as stored in this table.

Now, we want to write a query such that we output the MODULE_CODE, MODULE_NAME, PARENT_MODULE Code and also the Parent Module Name. For creating this output, we would need an outer join.

For this, in Tibero v6, we could write a SQL Query the same as available in Oracle as follows: