[gnome-db] GdaSqlBuiler: JOIN AS

Murray Cumming <[email protected]>
Newsgroups gmane.comp.gnome.db
Message-ID <1274083674.3092.51.camel@murrayc-desktop>
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


-- 
[email protected]
www.murrayc.com
www.openismus.com
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.