Skip to Content
0

join ESTRH to a subset

Nov 23, 2017 at 08:39 AM

27

avatar image
Former Member

Hello,

I am trying to join in sq02 (without abap) ESTRH to a subset but I do not understand how to join a table (estrh) to a subset (ESTRI innerJOIN ESTRI1) with the graphical interface of infoset.

Thanks for your help

In the below code, ESTRI1 is an alias of ESTRI

what i want to do :

Select *
From ESTRH
LEFT JOIN 
(
Select*
From ESTRI as E
INNER JOIN ESTRI1 as E1 on E.RECNROOT = E1.RECNROOT
) as EST
ON EST.RECNROOT = ESTRH.RECNROOT
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi Nov 23, 2017 at 09:43 AM
0

first create a dataflow and create a job using below query and load it into a staging

Select*From ESTRI asEINNERJOIN ESTRI1 as E1 onE.RECNROOT = E1.RECNROOT --- load this in a staging (STG_ESTRI1)

Now use below query and load final table

Select * From ESTRH

LEFTJOIN STG_ESTRI1

ON

STG_ESTRI1.RECNROOT = ESTRH.RECNROOT

Share
10 |10000 characters needed characters left characters exceeded