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