How to combine two unrelated tables in mysql

Question

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

TABLE1

table2

Result

Answer 1

You can also use this:

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

Answer 2

Try it.

  SELECT t2.date, t1.name FROM table1 t1, table2 t2 ORDER BY t1.name ASC 

Answer 3

Just try

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

Answer 4

Try the following: SELECT DATE, NAME FROM TABLE1, TABLE2

Answer 5

None of them will work.

If you want to know how to do it properly, I would suggest you take a look at this http://blog.codinghorror.com/a-visual-explanation-of-sql-joins/

CROSS JOIN not what you are looking for.

SQL will not be able to process this query. I suggest you make two sets of records with two different queries, and then sort them by field using PHP / Python / C or whatever your application is running on. Just do not leave this on the MySQL server because it cannot.