I have 2 tables, first one is material\_table:

| id | material |
| --- | --- |
| 1 | steel |
| 2 | aluminum |
| 3 | copper |
| 4 | nickel |

Second one is dimension\_table:

| width | length |
| --- | --- |
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 1 | 4 |

I want to join them so I have something like result\_table:

| material | width | length |
| --- | --- | --- |
| steel | 1 | 1 |
| steel | 1 | 2 |
| steel | 1 | 3 |

I tried the following:

```
SELECT material_table.type, dimension_table.width, dimension_table.length
FROM dimensions_table
CROSS JOIN material_table;

```

But I get a resulting table like:

| material | width | length |
| --- | --- | --- |
| steel | 1 | 1 |
| copper | 1 | 1 |
| nickel | 1 | 1 |
| steel | 1 | 2 |
| copper | 1 | 2 |
| nickel | 1 | 2 |

So to clarify I want to join my material table with the dimensions table, but the order of the columns is not the way I want it.