AnsweredAssumed Answered

Investment id not found

Question asked by William_W on Dec 16, 2013
Latest reply on Dec 16, 2013 by another_martink

The investment id not found in the INV_INVESTMENTS table but does exist in PRJ_BLB_SLICES_M_ALC table, Does anyone happen to know why?

Below is the SQL script and the return result

select distinct
PRJ_BLB_SLICES_M_ALC.INVESTMENT_ID,
INV_INVESTMENTS.ID
from NIKU.PRJ_BLB_SLICES_M_ALC
left join NIKU.INV_INVESTMENTS
on INV_INVESTMENTS.ID = INVESTMENT_ID
where INV_INVESTMENTS.ID is null

 

INVESTMENT_ID   |ID    |
5044410         |<NULL>|
5039605         |<NULL>|
5043518         |<NULL>|
5053664         |<NULL>|
5053651         |<NULL>|
5044411         |<NULL>|
5040516         |<NULL>|
5047553         |<NULL>|
5046445         |<NULL>|
5053660         |<NULL>|
5047593         |<NULL>|
5047567         |<NULL>|
 
 

Outcomes