1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

creating a schedule

Discussion in 'MySQL' started by xbat, Sep 13, 2017.

  1. #1
    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
     
    xbat, Sep 13, 2017 IP
  2. xbat

    xbat Well-Known Member

    Messages:
    326
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    105
    #2
    I found out what it was. A dynamic pivot table.
     
    xbat, Sep 13, 2017 IP