Why you don't use the coalesce function? El 12/10/2012 04:05, "Maxim Solodovnik" <solomax...@gmail.com> escribió:
> 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 >
