Hi,

At July 17, 2003, 23:43, Yosi wrote:

> Hello,

> Is it true that I cannot execute this statement on IBOConsole ?

Yes, it's true, you cannot write that kind of query in Interbase or
Firebird.

> 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.

Create a view that contains the query in your FROM clause. Then you
can use that view the same way as a table.

> 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

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)