Object-Relational queries are queries which can handle data object features on the existing relational data environment.
REF is one of most important data structures in Object-Relational Databases and can be explained as a logical pointer to define the
link between two tables with a similar function.
There are three ways of writing REF join queries which are:
- REF Join,
- Path Expression Join and
- DEREF/VALUE Join.