How to combine two unrelated tables in Mysql

Question

There are two tables that are not related to each other(No foreign keys). How to show them together in MySQL?

TABLE1

TABLE2

Result

Answer 1

You can use this too:

SELECT t2.date, t1.name
FROM table1 t1
CROSS JOIN table2 t2