From 3d893c8222646e95aeae0301d954cfe62aa8486a Mon Sep 17 00:00:00 2001
From: dmauri <dmauri@code.phpbb.com>
Date: Tue, 15 Nov 2011 22:19:45 +0100
Subject: [ticket/10296] Fix CROSS JOIN with INNER JOIN on MSSQL, Postgres and
 Oracle

PHPBB3-10296
---
 phpBB/includes/db/dbal.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'phpBB/includes/db/dbal.php')

diff --git a/phpBB/includes/db/dbal.php b/phpBB/includes/db/dbal.php
index 9b45c085a2..b4c1a72e1c 100644
--- a/phpBB/includes/db/dbal.php
+++ b/phpBB/includes/db/dbal.php
@@ -609,7 +609,7 @@ class dbal
 					}
 				}
 
-				$sql .= $this->_sql_custom_build('FROM', implode(', ', $table_array));
+				$sql .= $this->_sql_custom_build('FROM', implode(' CROSS JOIN ', $table_array));
 
 				if (!empty($array['LEFT_JOIN']))
 				{
-- 
cgit v1.2.1