Revision 4b8e5682
Von Tamino Steinert vor mehr als 1 Jahr hinzugefügt
- ID 4b8e56821eac8b83856dca20e2ca8371081c13f5
- Vorgänger 72b80f91
| SL/IR.pm | ||
|---|---|---|
| 1255 | 1255 |
my $query = |
| 1256 | 1256 |
qq|SELECT |
| 1257 | 1257 |
p.id, p.partnumber, p.description, p.lastcost AS sellprice, p.listprice, |
| 1258 |
p.unit, p.part_type, p.onhand, p.formel,
|
|
| 1258 |
p.unit, p.part_type, stocks.onhand, p.formel,
|
|
| 1259 | 1259 |
p.notes AS partnotes, p.notes AS longdescription, p.not_discountable, |
| 1260 | 1260 |
p.price_factor_id, |
| 1261 | 1261 |
p.ean, |
| ... | ... | |
| 1279 | 1279 |
pg.partsgroup |
| 1280 | 1280 |
|
| 1281 | 1281 |
FROM parts p |
| 1282 |
LEFT JOIN stocks ON (stocks.part_id = p.id) |
|
| 1282 | 1283 |
LEFT JOIN chart c1 ON |
| 1283 | 1284 |
((SELECT inventory_accno_id |
| 1284 | 1285 |
FROM buchungsgruppen |
Auch abrufbar als: Unified diff
Separate Tabelle für onhand (stocks) für Artikel