Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys, I have a doubt.
I want to make a join between two tables, but without a key, for example (Table A + Table B = Table C):
A:
| Item | Price |
|---|---|
| 1 | 2,95 |
| 2 | 1,88 |
B:
| Store |
|---|
| Store_1 |
| Store_2 |
| Store_3 |
| Store_4 |
| Store_5 |
C:
| Store | Item | Header 3 |
|---|---|---|
| Store_1 | 1 | 2,95 |
| Store_1 | 2 | 1,88 |
| Store_2 | 1 | 2,95 |
| Store_2 | 2 | 1,88 |
| Store_3 | 1 | 2,95 |
| Store_3 | 2 | 1,88 |
| Store_4 | 1 | 2,95 |
| Store_4 | 2 | 1,88 |
| Store_5 | 1 | 2,95 |
| Store_5 | 2 | 1,88 |
Hi Luiz,
LOAD * From B;
Left Join
LOAD * From A;

Regards,
Antonio