Re: [GENERAL] JOIN exclusion problem

Thank you both for your replies.  Unfortunately, the AND solution doesn't
work since individuals who have a value for ap.kunden_nr are not likely to
have one for ap.agentur_nr -- they are two fairly distinct groups.  When I
insert AND, the results are blank.

Any other suggestions?

At 16:23 01.07.99 +1000, you wrote:
>Try using AND instead of OR.
>

>> SELECT apartner_nr, ap.anrede, ap.vorname, ap.nachname, ap.telefon, ap.fax,
>> ap.email, ap.kunden_nr, k.name1, ap.agentur_nr, ag.name1
>> FROM ansprechpartner ap, kunden k, agenturen ag
>> WHERE ap.kunden_nr = k.kunden_nr OR ap.agentur_nr = ag.agentur_nr
>> ORDER BY nachname"

> SELECT apartner_nr, ap.anrede, ap.vorname, ap.nachname, ap.telefon, ap.fax,
> ap.email, ap.kunden_nr, k.name1, ap.agentur_nr, ag.name1
> FROM ansprechpartner ap, kunden k, agenturen ag
> WHERE ap.kunden_nr = k.kunden_nr OR ap.agentur_nr = ag.agentur_nr
                                   ^^
You might wanna try an AND there.

> ORDER BY nachname"