I have created a query using SQVI and using the table join of KNA1, ADRC and ADR6. The connecting point between KNA! and ADRC is KUNNR and ADDR. And the connetion between ADRC and ADR6 is between ADDR and ADDR.
The idea is to pass the customer number in KAN1 and get the address number through which we pass in ADRC to get the postal address and with the same address number we pass in ADR6 to get the email of the customer.
Im not getting any output for this combination. Can you please help?