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
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
