Skip to Content
avatar image
Former Member

join ESTRH to a subset

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 23, 2017 at 09:43 AM

    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

    Add comment
    10|10000 characters needed characters exceeded