4 Replies Latest reply: Dec 19, 2014 4:55 AM by Manoj Kulkarni RSS

    Tricky Join ....

    Phil Speight

      I am trying to link my health appointments to the rostering info so I can understand what shift someone was working on the day they attended a health appointment.

       

      I have the following tables :

       

      Health appointments

      Health Appointment Date

      Person First Name

      Person Last Name

      Person DOB

      Health reason

      HealthAppt_Person_ID

       

      Person Table

       

      Person First Name

      Person Last Name

      Person Staff Number

      Person DOB

      HealthAppt_Person_ID

      Roster_Person_ID

       

      Roster Table

       

      Roster Date

      Roster Shift Name

      Person Staff Number

      Person First Name

      Person Last Name

      Roster_Person_ID

       

       

       

      How do I show what shift the person was working on the date of the Health Appointment (without duplications)?

       

       

      Thanks in advance

       

       

       

      Phil