SELECT 'HelloWorld!' AS Filter, (SELECT COUNT(*) FROM ENT.[Reporting_Sent]) AS [Sent Units], (SELECT COUNT(*) FROM ENT.[Reporting_Bounce]) FROM ENT.[Reporting_Sent]
I am trying to create a DE but getting an error saying that "Old style JOIN (ANSI JOINs) syntax is not allowed"
How can I display two counts from two tables into one row?