COM_ASS_USER_TAB (with the foll. columns)
COM_SDG_SYSTEM_USERS_TAB (with the foll. columns)
I need to do outer join using ID from 1st table and USER_ID from 2nd table. Thats no hassle could do it.
But the conditions are they will be passing a System_ID as IN Parameter and i need to send a REF CURSOR back.
the foll. conditions have to be met.
1)IF system_id and access_level are empty, i want the record to be picked.
2)if system_id and access_level are not empty, i want the record to be picked.
I am passing the SQL query as a REF CURSOR to the front end.
When i combine all the conditions above with the outer join, its not working.
Outer join as of now is working below with the SQL
from COM_SDG_SYSTEM_USERS_TAB sdg,