[gnome-db] GdaSqlBuiler: JOIN AS

[Murray Cumming <murrayc murrayc com>]

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


-- 
murrayc murrayc com
www.murrayc.com
www.openismus.com