I had some code somewhere but can not seem to find what I had. Anyways I am trying to create schedule. One table has dates - 04-01-2017 04-02-2017 04-03-2017 then the next table has names john ben matt billy bob susan What I need to do is push out a query like this - date - pe work 1 - pe work2 pe work 3 - pe work4 pe work5 - pe work6 04-01-2017 john ben matt billy susan bob 04-02-2017 john matt billy susan bob ben 04-03-2017 john billy susan bob ben matt I tried searching google for schedules but i am not search the correct words I believe. I do not want names to repeat with who they are working with that week. My biggest issue I really stuck on is how do you join the date when there is no date to join on?? thanks