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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.