SELECT in SELECT

[Gruber_Hans_12345]

Kann ich so eine Anfrage erstellen ?

SQL-Code:

SELECT A.ID, (SELECT SUM(L.MENGE) FROM LAGER L WHERE L.ID = A.ID) AS LAGER_MENGE
FROM ARTIKEL A
WHERE LAGER_MENGE > 0

Oder muß ich immer :

SQL-Code:

SELECT A.ID, (SELECT SUM(L.MENGE) FROM LAGER L WHERE L.ID = A.ID) AS LAGER_MENGE
FROM ARTIKEL A
WHERE (SELECT SUM(L.MENGE) FROM LAGER L WHERE L.ID = A.ID) > 0