The Cross Join has an unfortunate name which implies one thing but does another, it is like asking “Ignore relationships just Give me all Possible Combinations”
I used the same 2 tables from the last example to show you what this produces
This is less of a Join and more of a Cross Product