Need little help with a query - Printable Version +- webERP Forum (http://www.weberp.org/forum) +-- Forum: webERP Discussion (http://www.weberp.org/forum/forumdisplay.php?fid=1) +--- Forum: How To ? (http://www.weberp.org/forum/forumdisplay.php?fid=6) +--- Thread: Need little help with a query (/showthread.php?tid=8200) |
Need little help with a query - HDeriauFF - 08-31-2018 Hi I'm trying to resort my inventory by best sellers when printing a price list I need to integrate to my selection the quantity of a stockid sold which is: Code: SUM(CASE WHEN stockmoves.type=10 To the following query (used in PDFPriceList) : Code: "SELECT prices.typeabbrev, So far, no luck putting a Code: INNER JOIN stockmoves ON stockmaster.stockid=stockmoves.stockid Thank you for your input! |