From cdf932b9f13923d5e0d7178bd0ca5022ad4d0fc0 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Tue, 15 Oct 2019 21:09:03 +0200
Subject: Inventur: fix mysql query

---
 Inventur | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Inventur b/Inventur
index 794efa1..2c99328 100755
--- a/Inventur
+++ b/Inventur
@@ -161,7 +161,7 @@ fehlende_Barcodes=$(
 if [ -n "${fehlende_Barcodes}" ]; then
   >&2 printf 'Ich vermisse:\n'
   for Typ in "${!Spalten[@]}"; do
-    printf 'SELECT "%s",*' "${Typ}"
+    printf 'SELECT "%s",`%sn`.*' "${Typ}" "${Typ}"
     printf ' FROM `%sn`' "${Typ}"
     printf ' WHERE `%sn`.`Barcode` IN (' "${Typ}"
     printf 'FROM_BASE64("%s"),' ${fehlende_Barcodes} \
-- 
cgit v1.2.3-54-g00ecf