Revision a10943b5
Von Moritz Bunkus vor fast 17 Jahren hinzugefügt
| SL/AM.pm | ||
|---|---|---|
| 2518 | 2518 |
my $dbh = $form->get_standard_dbh($myconfig); |
| 2519 | 2519 |
|
| 2520 | 2520 |
my $query = qq|SELECT w.id, w.description, w.invalid, |
| 2521 |
(SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins,
|
|
| 2521 |
(SELECT COUNT(b.description) FROM bin b WHERE b.warehouse_id = w.id) AS number_of_bins |
|
| 2522 | 2522 |
FROM warehouse w |
| 2523 | 2523 |
ORDER BY w.sortkey|; |
| 2524 | 2524 |
|
Auch abrufbar als: Unified diff
Syntaxfehler in SQL-Query.