on 04-20-2009 11:22 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.