Hello,

Is it true that I cannot execute this statement on IBOConsole ? I found a classical error "Token unknown - line 3, char 6". I used to write a breakdowned SQL syntax like this on other tool (other dbms). How can I do this on IB & IBOConsole.

SELECT ID, Warehouse, SUM(InQty) AS InQty
FROM
(SELECT ID, Warehouse, InQty
FROM RawInA
UNION
SELECT ID, Warehouse, InQty
FROM RawInB) A
GROUP BY ID, Warehouse

from this table :

RawInA

ID Warehouse InQty
-------------------------------------------------
A1 W1 2
A2 W1 3
A3 W2 4

and RawInB

ID Warehouse InQty
-------------------------------------------------
A1 W3 10
A2 W3 10
A3 W2 2


[Non-text portions of this message have been removed]