Re: [gnome-db] GdaSqlSelectJoin
- From: Piotr Pokora <piotrek pokora gmail com>
- To: Vivien Malerba <vmalerba gmail com>
- Cc: gnome-db list <gnome-db-list gnome org>
- Subject: Re: [gnome-db] GdaSqlSelectJoin
- Date: Tue, 02 Mar 2010 22:02:10 +0100
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]