[SQL] 纯文本查看 复制代码
SELECT [/size]
sum(Table__2."Quantity"),
sum(Table__1."GrossAmount"),
Table__1."OrderId",
Table__2."OrderItem"
FROM
"OPENSAP.workshop::header" Table__1 INNER JOIN "OPENSAP.workshop::item" Table__2 ON (Table__1."OrderId"=Table__2."OrderId")
GROUP BY
Table__1."OrderId",
Table__2."OrderItem"
[SQL] 纯文本查看 复制代码
SELECT
COALESCE( F__1.Axis__1,F__2.Axis__1 ),
COALESCE( F__1.Axis__2,F__2.Axis__2 ),
F__1.M__3,
F__2.M__3
FROM
(
SELECT
Table__1."OrderId" AS Axis__1,
Table__2."OrderItem" AS Axis__2,
sum(Table__1."GrossAmount") AS M__3
FROM
"OPENSAP.workshop::header" Table__1 INNER JOIN "OPENSAP.workshop::item" Table__2 ON (Table__1."OrderId"=Table__2."OrderId")
GROUP BY
Table__1."OrderId",
Table__2."OrderItem"
)
F__1
FULL OUTER JOIN
(
SELECT
Table__1."OrderId" AS Axis__1,
Table__2."OrderItem" AS Axis__2,
sum(Table__2."Quantity") AS M__3
FROM
"OPENSAP.workshop::header" Table__1 INNER JOIN "OPENSAP.workshop::item" Table__2 ON (Table__1."OrderId"=Table__2."OrderId")
GROUP BY
Table__1."OrderId",
Table__2."OrderItem"
)
F__2
ON ( F__1.Axis__1=F__2.Axis__1 AND F__1.Axis__2=F__2.Axis__2 )