Skip to Content
avatar image
Former Member

When i am trying to join two tables using left outer join in BODS, i am getting NULL value as output

Here is the output.... Please help me out

capture11.png (24.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 31, 2017 at 07:39 AM

    Hi Poonam Tiwari,

    DEPARTMENT column is from left table or right table?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Poonam Tiwari,

      DEPARTMENT column got NULL values because No record met the join condition. as it is LEFT OUTER JOIN left table will give values and if the join condition fails right table COLUMN will get NULLs. Right table column gets values only for the records that pass join condition.

  • avatar image
    Former Member
    Jul 31, 2017 at 01:37 PM

    can we see what are the tables/data on the left table and also on the right table?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Charity,

      My issue was resolved.actually i was doing silly mistake, i was trying to join column which have different value for department id :)