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

[poonam96]

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

[former_member490928]

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

[poonam96]

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 🙂

[former_member208402]

Hi Poonam Tiwari,

DEPARTMENT column is from left table or right table?

[poonam96]

Hi Ravi

DEPARTMENT column is from right table.

[former_member208402]

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.