How to combine two unrelated tables in Mysql

mysql select cartesian-product cross-join
Seehyung Lee picture Seehyung Lee · Jul 13, 2013 · Viewed 7k times · Source

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

TABLE1

enter image description here

TABLE2

enter image description here

Result

enter image description here

Answer

Iswanto San picture Iswanto San · Jul 13, 2013

You can use this too:

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

Related questions

MySQL - UPDATE query based on SELECT Query

I need to check (from the same table) if there is an association between two events based on date-time. One set of data will contain the ending date-time of certain events and the other set of data will contain the …

Read More
SQL query return data from multiple tables

I would like to know the following: how to get data from multiple tables in my database? what types of methods are there to do this? what are joins and unions and how are they different from one another? When …

Read More
Create a temporary table in a SELECT statement without a separate CREATE TABLE

Is it possible to create a temporary (session only) table from a select statement without using a create table statement and specifying each column type? I know derived tables are capable of this, but those are super-temporary (statement-only) and I …

Read More