From: Jan Büren <jan@lx-office-hosting.de>
Date: Thu, 12 May 2011 11:10:08 +0000 (+0200)
Subject: Bug 1597 - Report Lagerbestand wirft Fehler, wenn Artikelnummer ausgeblendet werden... 
X-Git-Tag: release-2.6.3~25^2~42
X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/commitdiff_plain/f71b2873b17c2c17ad9b71139cb389f689645ad4?ds=inline;hp=f71b2873b17c2c17ad9b71139cb389f689645ad4

Bug 1597 - Report Lagerbestand wirft Fehler, wenn Artikelnummer ausgeblendet werden soll

SELECT b.id AS binid, p.description AS partdescription, b.description AS
bindescription, i.warehouse_id AS warehouseid, i.chargenumber AS chargenumber,
w.description AS warehousedescription, i.parts_id AS parts_id, SUM(i.qty) AS
qty, p.unit AS partunit
FROM inventory i
LEFT JOIN parts p ON i.parts_id = p.id
LEFT JOIN bin b ON i.bin_id = b.id
LEFT JOIN warehouse w ON i.warehouse_id = w.id

WHERE 1=1
GROUP BY binid, partdescription, bindescription, warehouseid, chargenumber,
warehousedescription, parts_id, partunit
ORDER BY partnumber ASC
FEHLER: Spalte »p.partnumber« muss in der GROUP-BY-Klausel erscheinen oder in
einer Aggregatfunktion verwendet werden
---