Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, my question is a little bit tricky but i think that easy to understand. I have 2 tables:
Products:
Prod No 1
Prod No 2
and
Month:
1
2
3
4
What I want is to merge them ion the script so I have:
Products Month
Prod No 1 1
Prod No 1 2
Prod No 1 3
Prod No 1 4
Prod No 2 1
Prod No 2 2
Prod No 2 3
Prod No 2 4
is there any way?
I guess join them (there will be a Cartesian Product which isn't the best of things, but it will give you what you want)
Table:
LOAD Products
FROM ....;
Join (Table)
LOAD Month
FROM ....;
I guess join them (there will be a Cartesian Product which isn't the best of things, but it will give you what you want)
Table:
LOAD Products
FROM ....;
Join (Table)
LOAD Month
FROM ....;
Just put a join keyword between both load statement.
Omg... I was looking for left, rights joins even inner and what i needed is just join.. xD Well, actually the cartesian prod is what I was looking for, thanks