SQ01 / SQ02: Query problem

[Former Member]

Hello experts,

I'm creating one query about email addresses of customers. But I also want to display customers without email address.

The tables involved in query are: KNA1 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.

I joined table KNA1 and ADR6 by fields KNA1-ADRNR and ADR6-ADDRNUMBER as Left Outer Join.

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

[Former Member · Accepted solution]

Juan,

What selection criteria u have taken? as i tried here the blank field are also coming and i have only taken customer number.

Thanks,

Raja

[Former Member · Accepted solution]

Sorry,

I made a mistake. It's working OK

Thanks,

Juan