Question Re: Implementing NULL through HANA graphical in Technology Q&A

Implementing NULL through HANA graphical

ashutosh_shrivastava4 — Wed, 17 Jul 2019 10:19:02 GMT

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 — Wed, 17 Jul 2019 10:45:42 GMT

What difficulties are you expecting to do the same graphically ?

lyroj — Thu, 18 Jul 2019 11:39:10 GMT

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

FCI — Thu, 18 Jul 2019 12:16:23 GMT

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

ashutosh_shrivastava4 — Fri, 19 Jul 2019 08:46:39 GMT

Thanks...Its worked..