Implementing NULL through HANA graphical

[ashutosh_shrivastava4]

Hi,

Below is the requirement--

To achieve the same , Select A.ID FROM "TABLE_A" AS A LEFT OUTER JOIN "TABLE_B" AS B ON A.ID = B.ID WHERE B.ID IS NULL

Please suggest how to implement ( NULL ) through HANA graphical approach.

Thanks,

Ashutosh

[FCI · Accepted solution]

a left outer join then a projection with a filter on b field = NULL

[ashutosh_shrivastava4 · Accepted solution]

Thanks...Its worked..

[lyroj]

Problem is how to get data (6,7,8,9,10) from Table A.

[FCI]

What difficulties are you expecting to do the same graphically ?