Hi I'm trying to narrow down my search, I need to group by the GUID and grab the max value from the two queries that were union.

Working union script

Select * from memory\m2 as X
union
select * from memory\m3 as y

my goal is to do something along the lines of this sql statement

select GUID, Max(amount) as Amount from
     (Select * from memory\m2 as X
     union
     select * from memory\m3 as y) as z")
group by GUID

Both X and Y have 2 columns [GUID, Amount]

May I ask how would I selected from the union?

Bump

Boss

<<
Hi I'm trying to narrow down my search, I need to group by the GUID and grab the max value from the two queries that were union.

Working union script

Select * from memory\m2 as X
union
select * from memory\m3 as y

my goal is to do something along the lines of this sql statement

select GUID, Max(amount) as Amount from
     (Select * from memory\m2 as X
     union
     select * from memory\m3 as y) as z")
group by GUID

Both X and Y have 2 columns [GUID, Amount]

May I ask how would I selected from the union?
>>

Select * INTO MEMORY\M4 from memory\m2 as X
union
select * from memory\m3 as y
;
select GUID, Max(amount) as Amount from memory\m4
group by GUID