On 17 May 2010 14:39, Murray Cumming <[email protected]> wrote: > 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? >
The alias is for a target (table or sub select), not for a join: you don't need to name joins as they are never referenced anywhere else in the SQL statement, you can name targets if necessary. Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
