SQVI autojoin wrong - how to change

[sssaimbhi]

Dear All,

Kindly help me on this.

I am trying to get email address of vendors.

Joining two tables LFA1 & ADR6 as per screenshot gives me following results:

I want to pass the value of ADRNR field into ADDRNUMBER as it will solve my whole problem. Kindly let me know the piece of coding if Any needed to use in SQ02 to do this and where to do this coding.

Thanks in advance.

[JL23 · Accepted solution]

click the connection line, right mouse click , delete, then mouse click on ADRNR and drag it to ADDRNUMBER

[sssaimbhi · Accepted solution]

SOLVED THANKS.

I WAS TOO CLOSE. I WAS DRAGGING THE CONNECTION LINE only<LOL>.

ANYWAY THANKS JURGEN L 🙂