It's a join. A join without any ON or USING clause or any filtering is a Cartesian product which is what's happening here.