--
äÏÂÒÏÇÏ ÄÎÑ,

CREATE TABLE A (
    AF1  INTEGER,
    AF2  DOUBLE PRECISION
);

CREATE TABLE B (
    BF1  INTEGER,
    BF2  DOUBLE PRECISION
);

SELECT AF1, SUM(AF2), 0.0 FROM A
GROUP BY AF1
UNION ALL
SELECT BF1, 0.0, SUM(BF2) FROM B
GROUP BY BF1

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Invalid command.
Data type unknown.


îÁ FB 2.0 Beta 2 (12044) ×ÓÅ ÒÁÂÏÔÁÅÔ ×Ï ×ÓÅÈ ÄÉÁÌÅËÔÁÈ.
îÁ FB 1.5.1 É 1.5.3 ÒÁÂÏÔÁÅÔ ÔÏÌØËÏ × 1Í ÄÉÁÌÅËÔÅ, Á × 3Í ×ÙÄÁÅÔ 
×ÙÛÅÕËÁÚÁÎÎÕÀ ÏÛÉÂËÕ.

ú ÐÏ×ÁÇÏÀ,
óÅÒÇ?Ê àÒ?ÊÏ×ÉÞ þÅÒÎÑË



Ответить