Creating query (SQ01) about customer data
I'm creating one query about customers data
The tables involved in query are: KNA1, KNVV, KNVP, PA0002 and ADR6.
Table ADR6 contains the email address of customer, but not all customers have the emails address informed. Therefore not all customers have record in this table.
When I execute query, the customers without any record in ADR6 are not displayed in the list.
How could I display on the query list also the customers without record in ADR6 ? (Displaying BLANK as e-mail address).
While linking Tables to ADR6, put ADR6 Right side of the other table, click on joint and make sure that is only connected with the customer number, delete all other joints (if there).
Execute again, sure u will get.