Issue Bug Closed

#22501Multiple join conditions are not supported

Xavier Perseguers 04/22/10, 14:16 updated 06/19/10, 14:56

Description

Multiple conditions on a join cannot be parsed:

$rec = $GLOBALS[‘TYPO3_DB’]->exec_SELECTquery(
‘*’,
‘T1 LEFT OUTER JOIN T2 ON T2.pid=T1.uid AND T2.size=4’,
‘T1.cr_userid=1’
);

Problem is that this query cannot be rewritten due to the T2.size=4 which cannot be moved to the WHERE clause and cannot be left alone as left outer join condition.

(issue imported from #M14182)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.