Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, ...

In order to use UNION, the column list for all the SELECTS must be the same (at least in type/length), since it's returning a single resultset; you're basically trying to return both the email and the ...