Hello,
does anybody knows if is there any support for "LEFT OUTER JOIN ON"
construction (Or maybe any plan to support it)?
I would like to perform join of 2 tables and set values to NULL in case
there are no values.
In MySQL it can be written as follows:
SELECT t0.id, t1.id
FROM
fieldvalues t0
LEFT OUTER JOIN fieldlanguagesvalues t1 ON (t0.id = t1.fieldvalues_id
AND t1.language_id = 34)
WHERE t0.deleted = 0 LIMIT 50;
This query will select all fieldvalues and will add
existent fieldlanguagesvalues or NULL.
Thanks in advance
--
WBR
Maxim aka solomax
