MySQL Join is the same as Cross Join?
INNER, OUTER, and CROSS are ignored by MySQL.  The ON and WHERE control which type of JOIN it is.

In your examples you have nothing tying the tables together, hence operates like a CROSS JOIN.

GROUP BY, etc have no impact.