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
Attachment:
signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil