
09.06.2015, 19:45
|
Модератор
|
|
Регистрация: 17.04.2008
Сообщения: 8,087
Версия Delphi: 7, XE3, 10.2
Репутация: 49089
|
|
Сложный зпрос получится.
Код:
SELECT SUM(c1), SUM(c2), SUM(c3) FROM
(
SELECT SUM(PRICE) as c1, null as c2, null as c3 FROM OOC WHERE ID_MASTER=:id1 AND DATE_END>= :d1
UNION ALL
SELECT null as c1, SUM(PRICE) as c2, null as c3 FROM OOC WHERE ID_MASTER=:id2 AND DATE_END>= :d2
UNION ALL
SELECT null as c1, null as c2, SUM(PRICE) as c3 FROM OOC WHERE ID_MASTER=:id3 AND DATE_END>= :d3
)
Если БД такое съест...
|