Week numbers against employee

[kisnay82]

Hi

I have 2 tables, one table is a list of week numbers and the second table is employee details.

i want to create a query where each employee has a week number, so employee int2 has 52 weeks and employee int7 has 52 weeks.

for example

[TABLE="width: 500"]
<tbody>[TR]
[TD]Week Number[/TD]
[TD]Employee ID
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]int2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]int8[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]int5[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]int5[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]int5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]int5[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]int5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]int5[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]int5[/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

Simply do a query between the two, and do not create a Join between the two.
This will create a Cartesian product between the two tables, which is what you are describing.

 

[kisnay82]

Brilliant,

thank you

 

[xenou]

I'd also caution here that before proceeding you think about what happens 53 weeks from now. I see a lot of work done that is only for "one year" and then people spend a day or two resetting their spreadsheets for the new year because they can't just roll into the new year. I know this isn't a spreadsheet - but the same caveat applies.