In mysql How can I multiply two tables?

database, mysql, sql

Solution

Select student, number, from t1, t2;

Problem

Basically what I want is cross product of two tables. ``` t1 is : +------------+ | student | +------------+ | 1234567890 | | 1234567890 | | 1234567890 | | 000000001 | +------------+ t2 is: +--------+ | number | +--------+ | 1 | | 3 | +--------+ ``` How can I get a table which has two columns and 8 entries which are crosss product of values in t1 and t2 ?

Original source