Skip to Content
avatar image
Former Member

Creating query (SQ01) about customer data

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Apr 20, 2009 at 11:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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