SQL Verknüpfung

[Pikachu]

Versuch's mal so:

 
SELECT   A.NR, B.NR, ' ' AS ART, B.NAME, B.ORT
FROM     ADRESSEN AS A, ADRESSEN AS B
WHERE    A.NR=B.NR
UNION

SELECT   A.NR, B.NR, '*' AS ART, B.NAME, B.ORT
FROM     ADRESSEN AS A, ADRESSEN AS B, VERKNUPF
WHERE    A.NR=VN AND ZN=B.NR

ORDER BY 1, 3, 2, 4