Re: SELECT über zwei Tabellen
Drei SELECTs:
SELECT lagernr, (SELECT SUM(menge) FROM lager WHERE lagerNr=l.lagerNr)-
(SELECT SUM(menge) FROM ausgang WHERE lagerNr=l.lagerNr)) AS m
FROM lager l GROUP BY lagernr HAVING m>0
Subject
Views
Written By
Posted
1707
July 19, 2012 12:21PM
Re: SELECT über zwei Tabellen
971
July 21, 2012 02:59PM
916
August 06, 2012 10:53AM
1091
August 06, 2012 12:59PM
1074
August 06, 2012 11:57PM
1070
August 07, 2012 01:07AM
1020
August 07, 2012 09:50AM
1153
August 07, 2012 03:33PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.