simple solution could be
add a record with RYOTNUMBER=0 in the master and then use
NVL function.
OR
use OUTER JOIN.
If you are not OK with the solution, let me know.
Type: Posts; User: kishore_m_k; Keyword(s):
simple solution could be
add a record with RYOTNUMBER=0 in the master and then use
NVL function.
OR
use OUTER JOIN.
If you are not OK with the solution, let me know.