--- a/fhiiqm/inc/produkt_dat_show.inc.php	Fri Nov 16 10:40:03 2012 +0100
+++ b/fhiiqm/inc/produkt_dat_show.inc.php	Fri Dec 21 15:31:50 2012 +0100
@@ -22,13 +22,13 @@
             }
             echo "<tr><td>Produkt-Hierarchie: </td><td>" . $phier . "<td></td></tr>\n";
             // Arbeitsgruppe
-            $sql = "SELECT ag_ID, ag_name, abt_name FROM Arbeitsgruppe g INNER JOIN Abteilung a 
+            $sql = "SELECT rag_ID, rag_bez, abt_name FROM RaumArb_Gruppe g INNER JOIN Abteilung a 
                         ON g.abt_ID = a.abt_ID
-                        WHERE ag_ID = '" . $prod["ag"] ."' ";
+                        WHERE rag_ID = '" . $prod["ag"] ."' ";
             if ($result = $dbc->queryObjectArray($sql))
             {
                 foreach ($result as $row)
-                echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->ag_name . "</td></tr>\n";
+                echo "<tr><td>zugeordnet zu AG: </td><td>" . $row->rag_bez . "</td></tr>\n";
             }
             // Wichtigkeit
             $sql = "SELECT imp_ID, imp_name_s FROM Wichtigkeit WHERE imp_ID = " . $prod["imp"];