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?