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