Re: [gnome-db] GdaSqlSelectJoin
Piotr Pokora <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
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