Thanks for the quick reply :), I'm sure how coalesce can help me. Can you write a short example?
Thanks in advance :) On Fri, Oct 12, 2012 at 7:13 PM, José Luis Cetina <maxtorz...@gmail.com>wrote: > 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 > > > -- WBR Maxim aka solomax
