Hello all,
I am building a query to retrieve all projects attached to program or not. The query is working fine but gives duplicated results, one line with the program name and the second with 'null'.
here is the simple query :
SELECT II_PRJ.NAME AS PROJECT,
II_PRG.NAMEASPROGRAM
FROMINV_INVESTMENTS II_PRJ
LEFTOUTERJOININV_PROJECTS IP_PRJ ONII_PRJ.ID=IP_PRJ.PRID ANDIP_PRJ.IS_PROGRAM=0
LEFTOUTERJOININV_HIERARCHIES II_LINK ONII_PRJ.ID=II_LINK.CHILD_ID
LEFTOUTERJOININV_INVESTMENTS II_PRG ONII_LINK.PARENT_ID=II_PRG.ID
LEFTOUTERJOININV_PROJECTS IP_PRG ONII_PRJ.ID=IP_PRG.PRID ANDIP_PRG.IS_PROGRAM=1
WHEREII_PRJ.CODE IN('2016-AAE','PRJ000571')
Thank you for your help.
Karim