--- 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))
{