Re: [gnome-db] GdaSqlSelectJoin



Vivien Malerba pisze:

Hi!

> Yes, the GdaSqlSelectJoin's structure is valid (I mean no wild pointers, ...)
> 
> However this would translate as
> ... FROM ... LEFT JOIN ... ON (style) USING (t1.style, style.id)
> which is not what you want: you need to either define the USING part
> or the ON part, more likely in your case:
> ... ON (t1.style=style.id)
> 
> So the "style" has to be defined as a GdaSqlSelectTarget and the

Should I add table_name to GdaSqlSelectTarget and this one append to
targets? It creates 'FROM tbl1, tbl2' which is not valid for JOIN.

> join->on has to point to a GdaSqlExpr representing the

Hmmm... What is 'join->on' ?

> "t1.style=style.id" condition (the same construct as for the WHERE
> clause applies here), and join->use = NULL.

OK. Thanks for 'join->use' tip!

Piotras



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]