On Mon, 2010-05-17 at 14:20 +0200, Vivien Malerba wrote: > On 17 May 2010 10:07, Murray Cumming <[email protected]> wrote: > > In Glom, I use the AS keyword with JOINS, to allow multiple joins with > > the same table. A simple case looks like this, though it's unnecessary > > in this particular example: > > > > SELECT "albums"."album_id", "albums"."name", "albums"."artist_id", > > "relationship_artist"."name", > > FROM "albums" > > LEFT JOIN "artists" > > AS "relationship_artist" > > ON ("albums"."artist_id" = "relationship_artist"."artist_id") > > WHERE "albums"."album_id" = 123 > > > > (That might be an "alias", but I don't know if that's the right > > terminology.) > > > > But I don't see how to do that with > > gda_sql_builder_select_join_targets() > > http://library.gnome.org/devel/libgda/unstable/GdaSqlBuilder.html#gda-sql-builder-select-join-targets > > > > To do this you need to specify an alias when using the > gda_sql_builder_select_add_target*() methods.
But that's for adding table targts, right? How would it know which join the alias name is for? -- [email protected] www.murrayc.com www.openismus.com _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
