Skip to Content
0

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

Jul 31, 2017 at 07:21 AM

63

avatar image
Former Member

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

capture11.png (24.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ravi kiran Pagidi Jul 31, 2017 at 07:39 AM
0

Hi Poonam Tiwari,

DEPARTMENT column is from left table or right table?

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Ravi

DEPARTMENT column is from right table.

0

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.

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

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

Show 1 Share
10 |10000 characters needed characters left 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 :)

0