A powerful design mode makes query design much easier. But sometimes
(especially when using OUTER JOIN) I was not able to generate a working
query in design mode with OOO320m12 German.
But there is the wonderful SQL mode which offers me the opportunity to
formulate such OJ queries.
If I accidentally load this query into design mode, and store this
afterwords a working SQL query like this
SELECT "Kontakte"."KontaktArt" || ' N.' || coalesce(
"Kontakte"."RechnungsNr", '???' ) || ' del ' || "Kontakte"."Datum" ||
coalesce( ' ' || "Kontakte"."Anmerkung", '' ) || coalesce( (
"Kontakte"."Frachterlass" ), ' franco' ) || coalesce( '(' ||
"Kontakte"."Frachtkosten" || ')', '' ) AS "DOCUMENTO DI ", coalesce(
"Kunden_1"."Firma" || coalesce( ', ' || "Kunden_1"."Adresse" || ', ' ||
"Kunden_1"."Postleitzahl" || ' ' || "Kunden_1"."Ort", '' ) || ' P.
Iva/C.F. ' || coalesce( "Kunden_1"."PI", '' ) || coalesce( '/' ||
"Kunden_1"."CF", '' ), '' ) AS "DESTINATARIO", "Kunden"."Firma" ||
coalesce( ', ' || "Kunden"."Adresse" || ', ' || "Kunden"."Postleitzahl"
|| ', ' || "Kunden"."Ort", '' ) || ' P. Iva/C.F. ' || coalesce(
"Kunden"."PI", '' ) || coalesce( '/' || "Kunden"."CF", '' ) AS "Luogo di
destinazione", "Lieferungen"."Menge" AS "Quantità ",
"Lieferungen"."ISBNNummer" AS "cod. ISBN 13/ EAN", "Artikel"."Titel" AS
"Titolo", "Lieferungen"."Betrag" AS "Prezzo unitario/€",
"Lieferungen"."Rabatt" AS "Sconto", "Artikel"."Umsatzsteuer" FROM { OJ
"Kunden" AS "Kunden" LEFT OUTER JOIN "Personen" AS "Personen" ON
"Kunden"."PersonID" = "Personen"."PersonID" }, { OJ "Kontakte" LEFT
OUTER JOIN "Kunden" AS "Kunden_1" ON "Kunden_1"."KundenID" =
"Kontakte"."RechnungsKundenID" LEFT OUTER JOIN "Personen" AS
"Personen_1" ON "Kunden_1"."PersonID" = "Personen_1"."PersonID" },
"Lieferungen" AS "Lieferungen", "Artikel" AS "Artikel", "ArtikelArt" AS
"ArtikelArt" WHERE "Lieferungen"."ISBNNummer" = "Artikel"."ISBNNummer"
AND "Artikel"."ArtikelArt" = "ArtikelArt"."ArtikelArt" AND
"Lieferungen"."KontaktID" = "Kontakte"."KontaktID" AND
"Kontakte"."nachKundenID" = "Kunden"."KundenID" AND
"Kontakte"."Erledigt" <> True AND "ArtikelArt"."ArtikelArtDeutsch" <>
'Verpackung'
gets messed up to
same as above, but OJ "Kontakte" reorganized... , { OJ "Kunden" AS
"Kunden_1" LEFT OUTER JOIN "Kontakte" AS "Kontakte" ON
"Kunden_1"."KundenID" = "Kontakte"."RechnungsKundenID" LEFT OUTER JOIN
"Personen" AS "Personen_1" ON "Kunden_1"."PersonID" =
"Personen_1"."PersonID" }, "Lieferungen" AS "Lieferungen", "Artikel" AS
"Artikel", "ArtikelArt" AS "ArtikelArt" WHERE "Lieferungen"."ISBNNummer"
= "Artikel"."ISBNNummer" AND "Artikel"."ArtikelArt" =
"ArtikelArt"."ArtikelArt" AND "Lieferungen"."KontaktID" =
"Kontakte"."KontaktID" AND "Kontakte"."nachKundenID" =
"Kunden"."KundenID" AND "Kontakte"."Erledigt" <> True AND
"ArtikelArt"."ArtikelArtDeutsch" <> 'Verpackung'
With kind regards, Jan
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@de.openoffice.org
For additional commands, e-mail: users-h...@de.openoffice.org
