Support LEFT JOINs

diff --git a/lib/general.php b/lib/general.php
index 94365d8..2332e59 100644 (file)
--- a/lib/general.php
+++ b/lib/general.php
@@ -189,10 +189,16 @@ function debug_info()
 
 function grid_sql_join($mask)
 {
+  $ret = '';
   if (array_key_exists('join', $mask)) {
-    return ' JOIN ' . join(' JOIN ', $mask['join']);
+    foreach ($mask['join'] as $line) {
+      if (strtolower(substr($line,0,4)) == 'left')
+       $ret .= ' LEFT JOIN ' . substr($line,5);
+      else
+       $ret .= ' JOIN ' . $line;
+    }
   }
-  return '';
+  return $ret;
 }
 
 function grid_sql($name, $mask)