Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Solved