cancel
Showing results for 
Search instead for 
Did you mean: 

Creating query (SQ01) about customer data

Former Member
0 Kudos

Hello experts,

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).

Thanks

Juan

Accepted Solutions (1)

Accepted Solutions (1)

former_member208991
Participant
0 Kudos

Hi,

Change the join on table ADR6 to a left outer join. This will show all records in the linked table, for which no corresponding records exist in ADR6.

Hope this helps,

Regards

Nikhilesh

Former Member
0 Kudos

Thanks, Nikhilesh

Sorry but I'm not an expert. How can I change the join to a left outer join ?

Regards,

Juan

Former Member
0 Kudos

Juan,

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.

Thanks,

Raja

Answers (0)