How can I properly structure the below query to make it work? I would like to have the
Ref_CD = MBR_ID_TYPE_ID to be my select statement on the beginning of it.
select MBR_ID_TYP_ID || '-' || ( select ref_desc from ref where ref_nm='memberIDType' and REF_CD = MBR_ID_TYP_ID) as "Member Type", id.* from mbr_id id where mbr_id = 0989879;