In mysql How can I multiply two tables?

Question

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 ?

Answer 1

Select student, number, from t1, t2;

Answer 2

I think you need a CROSS JOIN.

It'll join both tables on all rows.

SELECT * FROM t1 CROSS JOIN t2