for each ?

[#1]

Hi all,

i have one table:

Year	YearMonth
2011	2011-1
2011	2011-2
2011	2011-3
2011	2011-4

(this goes on until the end of 2014...)

I have another table:

ID
A1
A2

(more records in here...)

Now what i want (in my LOAD script): For each YearMonth in my first table i want to add one ID. I need to do this for all IDs. That should result in one table looking like this:

Year	YearMonth	ID
2011	2011-1	A1
2011	2011-2	A1
2011	2011-3	A1
2011	2011-4	A1
2011	2011-1	A2
2011	2011-2	A2
2011	2011-3	A2
2011	2011-4	A2

How can i do this ?

Thanks a lot!

[#2]

Try this:

Load Year, YearMonth, 1 resident Table1;

join

load ID, 2 resident Table2;