Ergebnismenge wahlweise auf zwei Tabellen

[shmia]

SQL-Code:

SELECT ID, Detail1_ID AS Name, 1 AS Detail_Tab
FROM LISTE
WHERE NOT Detail1_ID IS NULL
UNION ALL
SELECT ID, Detail2_ID AS Name, 2 AS Detail_Tab
FROM LISTE
WHERE NOT Detail2_ID IS NULL