Counts from two tables in one query

If you’d like to get the total number of rows in two Data Extensions (or whatever tables) and do it in a single query, you can leverage CROSS JOINs like this:

Doing it this way will get you past the no-ANSI-JOINs restriction in SFMC.

Reference:

MSDN – Using Cross Joins

(Visited 439 times, 1 visits today)
Subscribe
Notify of
guest
2 Comments
Oldest
Newest
Inline Feedbacks
View all comments