Could anyone help me to join two tables without common columns?
I have two tables:
Tab1
| Column1 | Column2 |
|---|---|
| K1 | a |
| K2 | b |
Tab2
| Column1 | Column2 |
|---|---|
| K3 | c |
| K4 | d |
| K5 | e |
The result of select should be:
| Table1.Column1 | Table2.Column1 |
|---|---|
| K1 | K3 |
| K1 | K4 |
| K1 | K5 |
| K2 | K3 |
| K2 | K4 |
| K2 | K5 |
How do I do that?
Advertisement
Answer
Fiddle -> https://www.db-fiddle.com/f/ihJd4in3Tt7Fr8KZe6UvEC/0
select t1.column1, t2.column1 from table1 as t1 cross join table2 as t2;