Interbase supports:
SELECT CAST(0 AS Integer) MyName,
CAST(0 As Numeric(12,3)) Totals
FROM StockUsage
UNION
SELECT StockItemID, SUM(UsageAmount)
FROM StockUsage
GROUP BY StockItemID
what is the database you are using?
Max
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Darren J Gilbertson
Sent: Monday, 9 August 1999 11:49
To: Multiple recipients of list database
Subject: [DUG-DB]: SQL Problem
I would like to create a query using both UNION and GROUP BY.
I plan to combine to tables, then perform a group by on the combination. How
do I do this?
I have only managed to do a group by on the individual tables then combine
them, but I want to combine the tables first then do a group by.
Can somebody please help me.
Darren Gilbertson
[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
