fhiiqm/raum_aptyp_ed.php
changeset 27 d92bbe898f32
parent 26 3c1e3ac7089f
child 33 f1a8785434e4
--- a/fhiiqm/raum_aptyp_ed.php	Mon May 07 16:21:00 2012 +0200
+++ b/fhiiqm/raum_aptyp_ed.php	Fri Jun 08 15:04:22 2012 +0200
@@ -99,9 +99,9 @@
     {
         if ($apid && !$sub && !isset($ap))
         {
-            $sql = "SELECT geb_ID, a.raum_ID,a.arbplatz_typ
-                    FROM Raum_Arbplatz_Typ a INNER JOIN Raum r ON a.raum_ID = r.raum_ID
-                    WHERE a.raum_ID = $apid
+            $sql = "SELECT geb_ID, r.raum_ID,a.arbplatz_typ
+                    FROM Raum_Arbplatz_Typ a RIGHT OUTER JOIN Raum r ON a.raum_ID = r.raum_ID
+                    WHERE r.raum_ID = $apid
                     ORDER BY a.arbplatz_typ";
             if ($res = $dbc -> queryObjectArray($sql))
             {