Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2007
    Posts
    84

    Unanswered: Want to return an Outer join row

    Is there a way to return the "financial_trx" OBJECT_TYPE row when adding the
    commented SQL below C.ENTITY_MILESTONE_CODE IN ( etc...)?
    When I input the ('LPDRAFT_COMPLETE', 'APP_SUBMITTED', 'WAIT_FORDOCREQ', NULL) it does not return the financial_trx row. Is there a decode statement or something else that could be used?

    Attached is the data sample.


    SELECT DISTINCT A.ENTITY_ID,
    A.ENTITY_NO,
    A.OBJECT_TYPE,
    B.PRIMARY_USER,
    C.ENTITY_MILESTONE_CODE,
    C.MILESTONE_ACT_DATE START_DATE /* 674790400202287188' finance_request AND '5371275190677402941' financial_trx */
    FROM fc_uat.WBS_ENTITIES a,
    fc_uat.FC_ENTITY_TEAMS_V B,
    fc_uat.fc_entity_milestones_v c,
    fc_uat.WBS_WORKFLOW_RESP D
    WHERE a.entity_id = b.entity_id
    AND a.ENTITY_NO LIKE '132489%'
    AND A.CANCELED_FLAG <> 1
    AND a.entity_id = c.entity_id(+)
    --AND C.ENTITY_MILESTONE_CODE IN ('LPDRAFT_COMPLETE', 'APP_SUBMITTED', 'WAIT_FORDOCREQ', NULL)
    AND B.WORKFLOW_RESP_ID = D.WORKFLOW_RESP_ID
    AND D.NAME IN ('RCC Analyst')
    Attached Files Attached Files

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >--AND C.ENTITY_MILESTONE_CODE IN ('LPDRAFT_COMPLETE', 'APP_SUBMITTED', 'WAIT_FORDOCREQ', NULL)
    I could be totally off base, IIRC in a different forum recently this topic was discussed.
    Things might be better if you eliminate the ", NULL" from the top line above.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2007
    Posts
    84
    That doesn't work! I want the "financial_trx" row. If I take out the Null it doesn't make a difference. It still only returns the 'LPDRAFT_COMPLETE', 'APP_SUBMITTED', 'WAIT_FORDOCREQ' rows. I want it to return the blank row also.

    If you look at my attachment, you'll see the data.

  4. #4
    Join Date
    Nov 2002
    Posts
    272
    How about
    AND (C.ENTITY_MILESTONE_CODE IN ('LPDRAFT_COMPLETE', 'APP_SUBMITTED', 'WAIT_FORDOCREQ')
    OR C.ENTITY_MILESTONE_CODE IS NULL)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •