I have a patient that can be different from the insured name, say a spouse of the employee.
Spouse - Minnie Mouse
Employee - Mickey Mouse
If I want to show the Insured name on the spouse's record, how do I do that?
I want to show Mickey as the Insured and Minnie as the patient on 1 row.
The query below does this, but what if I have a big table that needs to find out who the insured
persons name and have it shown on the dependent or spouse's record?
Do I need to write a sub query to do this? This is based on the same table - MEM_MEMBER
This is part of a larger query and not separate and not to be joined on the '22222201-REGRESS2-'
constant value but joined somehow...
Using Oracle 11g
SELECT PATIENT.MEM_UID Pat_MEM_UID,
FROM MEM_MEMBER PATIENT,
WHERE PATIENT.MEM_ID = '22222201-REGRESS2-'
_HOLDER = INSURED.MEM_UID
(Attachment - raw data and result set from query above)