Simple Union Query with Max, Group (1 Viewer)

:banghead:UGH! This is so easy and I'm getting syntax errors.
I want to group the Activ_ID and Max the ActivEECO_UpdateDate fields.

SELECT
Activ_ID,
Activ_DatePosted as ActivEECO_UpdateDate
FROM Activity_Translated;

UNION ALL Select
Activ_ID,
ActivEECO_UpdateDate
FROM ActivityEECO_Translated;

Please help.
Thanks

You posted the SQL of a query. Save that query with the name 'sub1'. Then use this SQL to achieve what you want:



A UNION query should only be used to bring data together. When you want to do more, save the UNION then use it as the basis for another query.