select mehrte Spalten

[omata]

Ja, aber ohne Klammern...

SQL-Code:

CREATE VIEW view_artikel_anzahl
AS
SELECT art_1 AS art, 1 AS anzahl
FROM lieferung
WHERE art_1 > 0
UNION
SELECT art_2 AS art, 1 AS anzahl
FROM lieferung
WHERE art_2 > 0
UNION
SELECT art_3 AS art, 1 AS anzahl
FROM lieferung
WHERE art_3 > 0