wvpv/sfmc-sql-counts-from-multiple-tables-in-one-query.sql

## 11 changes: 11 additions & 0 deletions sfmc-sql-counts-from-multiple-tables-in-one-query.sql
@@ -0,0 +1,11 @@

    select
select

      de1.count1
  de1.count1

    , de2.count2
, de2.count2

    from (
from (

      select count(*) as count1
  select count(*) as count1

      from DataExtension1
  from DataExtension1

    ) as de1
) as de1

    cross join (
cross join (

      select count(*) as count2
  select count(*) as count2

      from DataExtension2
  from DataExtension2

    ) as de2
) as de2