I have a problem with the sintax below where i tried to union two DEs where the Month is the Primary Key. All Data Extension in the case have the fiedls type like Text.
ERROR: Query failed during execution. Error: Conversion failed when converting the nvarchar value 'July' to data type int.
select Count(*) as [Users], [Month] as [Month] FROM [DE_1] GROUP BY [Month] UNION Select [Month] as [Month], Send as [Sends_Totally] from [DE_2]