Hi,
I created a report based on a request.
But I'd like to add some field from another request.
How is it possible ?
Thanks
SELECT "Total", "A"."Marque", "A"."Largeur", "A"."Hauteur", "A"."Diametre", "A"."Charge", "A"."Vitesse" FROM "tPneus" "A"
INNER JOIN ( SELECT SUM( "tSorties"."QteSortie" ) "Total", "tSorties"."RefPneu"
FROM "tSorties", "tRapport", "tPneus"
WHERE
( "tSorties"."DteSortie" > "tRapport"."DateDébut" OR "tRapport"."DateDébut" IS NULL ) AND ( "tRapport"."DateFin" IS NULL OR "tSorties"."DteSortie" < "tRapport"."DateFin" ) AND ( "tRapport"."DateFin" IS NULL OR "tSorties"."DteSortie" < "tRapport"."DateFin" ) AND ( "tPneus"."IdPneu" = "tSorties"."RefPneu" ) AND ( "tRapport"."Marque" LIKE '' OR "tPneus"."Marque" LIKE "tRapport"."Marque" ) AND ( "tRapport"."Largeur" LIKE '' OR "tPneus"."Largeur" LIKE "tRapport"."Largeur" ) AND ( "tRapport"."Hauteur" LIKE '' OR "tPneus"."Hauteur" LIKE "tRapport"."Hauteur" ) AND ( "tRapport"."Diametre" LIKE '' OR "tPneus"."Diametre" LIKE "tRapport"."Diametre" ) AND ( "tRapport"."Charge" LIKE '' OR "tPneus"."Charge" LIKE "tRapport"."Charge" ) AND ( "tRapport"."Vitesse" LIKE '' OR "tPneus"."Vitesse" LIKE "tRapport"."Vitesse" )
GROUP BY "tSorties"."RefPneu" ) "B"
ON "A"."IdPneu" = "B"."RefPneu" ORDER BY "A"."Marque"
SELECT "tRapport"."DateDébut" , "tRapport"."DateFin" FROM "tRapport"
SELECT "Total", "A"."Marque", "A"."Largeur", "A"."Hauteur", "A"."Diametre", "A"."Charge", "A"."Vitesse"
, COALESCE("R"."DateDébut", '-') , COALESCE("R"."DateFin", '-')
FROM "tPneus" "A"
INNER JOIN ( SELECT SUM( "S"."QteSortie" ) "Total", "S"."RefPneu"
FROM "tSorties" "S"
INNER JOIN "tPneus" "P" ON "P"."IdPneu" = "S"."RefPneu"
, "tRapport" "R"
WHERE ( "R"."DateDébut" IS NULL OR "S"."DteSortie" > "R"."DateDébut" )
AND ( "R"."DateFin" IS NULL OR "S"."DteSortie" < "R"."DateFin" )
AND ( "R"."DateFin" IS NULL OR "S"."DteSortie" < "R"."DateFin" )
AND ( "R"."Marque" LIKE '' OR "P"."Marque" LIKE "R"."Marque" )
AND ( "R"."Largeur" LIKE '' OR "P"."Largeur" LIKE "R"."Largeur" )
AND ( "R"."Hauteur" LIKE '' OR "P"."Hauteur" LIKE "R"."Hauteur" )
AND ( "R"."Diametre"LIKE '' OR "P"."Diametre"LIKE "R"."Diametre" )
AND ( "R"."Charge" LIKE '' OR "P"."Charge" LIKE "R"."Charge" )
AND ( "R"."Vitesse" LIKE '' OR "P"."Vitesse" LIKE "R"."Vitesse" )
GROUP BY "S"."RefPneu"
) "B" ON "A"."IdPneu" = "B"."RefPneu"
, "tRapport" "R"
ORDER BY "A"."Marque"
Users browsing this forum: No registered users and 2 guests