Simple Union Query that adds payments

[TJVFree]

Hi,
I'm now to using Union query’s and would like to sum my payments in the query below.

SELECT [PayrollNo],[Name], [payment]
FROM [Table1]

UNION SELECT [PayrollNo],[Name], [payment]
FROM [Table2]

Thank you for your help

TCB

 

[Andrzejek]

I would try something like:

[blue]Select PayrollNo, MyName, SUM(MyPayement) As PaySum
From ([/blue]
SELECT [PayrollNo],[Name], [payment]
FROM [Table1]
UNION 
SELECT [PayrollNo],[Name], [payment]
FROM [Table2][blue]
) Group By PayrollNo, MyName[/blue]

BTW - 'Name' is a bad name for a field.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[PHV]

Like this ?
SELECT PayrollNo,[Name],Sum(payment) AS Total
FROM (SELECT [PayrollNo],[Name], [payment] FROM [Table1]
UNION SELECT [PayrollNo],[Name], [payment] FROM [Table2]) U
GROUP BY PayrollNo,[Name]


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TJVFree]

Thanks Andrzejek and PHV. I was able to get it to work with your help

TCB