[gnome-db] More SqlBuilder stuff

Hi Vivien!

I was trying to convert a rather complicated SQL into GdaSqlBuilder
statements but got stuck a bit:


SELECT "albums"."album_id", "albums"."name", "albums"."artist_id", 
"relationship_artist"."name", "albums"."publisher_id",
"relationship_publisher"."name",
"albums"."year", "albums"."comments" FROM "albums" LEFT JOIN
"publishers" AS "relationship_publisher"
ON ("albums"."publisher_id" =
"relationship_publisher"."publishers_id")  
LEFT JOIN "artists" AS "relationship_artist" ON ("albums"."artist_id" =
"relationship_artist"."artist_id")  WHERE "albums"."album_id" = 1 */

I got to the point of the first LEFT JOIN rather quickly but then I have
no real idea how to continue. This is what I have so far (it's in C++, I
can convert it to C if that's easier for you):

http://de.pastebin.ca/1600971

Thanks,
Johannes

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAkrMasUACgkQAvZZn2XJ+bPEtACfe/0eae3P0OMWh8RAsp00liE2
FuIAoKCJnjP5lYXK4QmnBex8e3Ld38D0
=G01x
-----END PGP SIGNATURE-----