Relate 2 Tables Without key

[Anonymous]

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?

[sunny_talwar · Accepted solution]

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 ....;

[ganeshsvm]

Just put a join keyword between both load statement.

[Anonymous]

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