sqlsql-merge

SQL query: merge 2 tables


I need to generate a SQL query for the following case:

First table:

column1
A
B

Second table:

column2
1
2
3
4

I want to create a query so the result will be like this:

column1 column2
A 1
A 2
A 3
A 4
B 1
B 2
B 3
B 4

Appreciate any answer, thank you.


Solution

  • Use a cross join between the two tables:

    SELECT t1.column1, t2.column2
    FROM FirstTable t1
    CROSS JOIN SecondTable t2
    ORDER BY t1.column1, t2.column2;