Build up a cross table

[#1]

Hi folks,

I've got a problem and can't get to the solution by myselfe.

I have 2 tables:

First table has got several periodes:

Periode

01-2010

02-2010

03-2010

04-2011

...

Second table is like:

Name; Start Periode; Cost per Periode

Power ; 01-2010; 210

Water; 03-2010; 150

...

Now I need to join both Tables. I want the result-table to look like:

Periode; Costs; Name

01-2010; 210; Power

02-2010; 210; Power

03-2010; 210; Power

03-2010; 150; Water

04-2010; 210; Power

04-2010; 150; Water

...

Has anyone got a hint for me?

Thanks a lot ... Stefan

[#2]

Solved