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

Week Number	Employee ID
1	int2
2	int2
3	int2
4	int2
5	int2
6	int2
7	int2
1	int8
2	int8
3	int8
4	int8
5	int8
6	int8
7	int8
1	int5
2	int5
3	int5
4	int5
5	int5
6	int5
7	int5

<tbody>
</tbody>

 

[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.