wenn ich das nun so mache:
SQL-Code:
SELECT ART.*,SP.* FROM ART INNER JOIN SP ON ART.ID=SP.ID_ART
WHERE ID_KUNDE = 661 AND VP <> 0
UNION
SELECT ART.*,PG.* FROM ART INNER JOIN PG ON ART.ID=PG.ID_ART
WHERE PGNR = 1
kommt diese Fehlermeldung:
count of column list and variable list do not match.