Add specific value to columns resulting in doubling number of rows

[#1]

Hi guys ... I need some help for the following problem.

In my loading Script I have two tables:

Table1: some Markets with some Articles

Market	Article
1	c
1	a
1	b
2	a

Table2: All Deliverer for each combination of Market and Article

Market	Article	Deliverer
1	a	500
1	b	500
1	c	100
2	a	100

Now I want to join both tables.

Looks like this:

Market	Article	Deliverer
1	c	100
1	a	500
1	b	500
2	a	100

Until here I have no problems.

Now I want to add the Value '0' to "Deliverer" for each row of the third table (this will double the number of rows).

Result should look like this table:

Market	Article	Deliverer
1	c	0
1	c	100
1	a	0
1	a	500
1	b	0
1	b	500
2	a	0
2	a	100

Anybody got an idea how I can create this last table?

Thanks for your help!

[flipside · Accepted solution]

Hi mathiass,

If I understood right, just use ...

Markets:

Load Market, Article, 0 as Deliverer

resident Markets;

flipside

[#3]

Thanks a lot  ... works fine