From: | Anja Speerforck <anja(at)damn(dot)com> |
---|---|
To: | "Ross J(dot) Reedstrom" <reedstrm(at)wallace(dot)ece(dot)rice(dot)edu> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] JOIN exclusion problem |
Date: | 1999-07-01 17:14:16 |
Message-ID: | 199907011718.NAA24299@chet.brysonweb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Peter and Ross for suggesting the correct solution. It works with
the following code:
SELECT apartner_nr, ap.anrede, ap.vorname, ap.nachname, k.name1,
ap.telefon, ap.fax, ap.email
FROM ansprechpartner ap, kunden k
WHERE ap.kunden_nr = k.kunden_nr
UNION
SELECT apartner_nr, ap.anrede, ap.vorname, ap.nachname, ag.name1,
ap.telefon, ap.fax, ap.email
FROM ansprechpartner ap, agenturen ag
WHERE ap.agentur_nr = ag.agentur_nr
ORDER BY nachname;
Best regards,
Anja
At 09:49 01.07.99 -0500, you wrote:
>Ah, now it's clear. You're looking for the UNION operator, and two selects.
>Something like:
>
>SELECT apartner_nr, ap.anrede, ap.vorname, ap.nachname, ap.telefon, ap.fax,
>ap.email, ap.kunden_nr, k.name1
>FROM ansprechpartner ap, kunden k
>WHERE ap.kunden_nr = k.kunden_nr
>UNION
>SELECT apartner_nr, ap.anrede, ap.vorname, ap.nachname, ap.telefon, ap.fax,
>ap.email, ap.agentur_nr, ag.name1
>FROM ansprechpartner ap, agenturen ag
>WHERE ap.agentur_nr = ag.agentur_nr
>ORDER BY nachname
_____________________________
>In this case you should try a union like
>SELECT ... FROM ap, k WHERE ap.kunden_nr = k.kunden_nr
>UNION
>SELECT ... FROM ap, ag WHERE ap.agentur_nr = ag.agentur_nr
>ORDER BY nachname;
>
>(Note the target lists.)
From | Date | Subject | |
---|---|---|---|
Next Message | Leon | 1999-07-01 18:42:48 | Bounced bugreport |
Previous Message | Michael Edwin Haberman | 1999-07-01 16:34:46 | help with SPI_<commands> Please |