5 Replies Latest reply: Nov 21, 2014 3:19 PM by Jonathan Poole RSS

    How to do this - do I have to join or what?

    Friedrich Hofmann

      Hi,

       

      I have the following requirement:

       

      - I have a table with a series of bookings, each one with a date, a user_name who did it and a week that I created

      - On the other hand, I have a table with a nr. of names (of employees who were assigned to a specific area in a specific week) with a
         week_number.

       

      => Now I want to filter the table with bookings for only those ´bookings which were made by employees who were assigned a specific
           area - in the week of the booking.

       

      => How would I go about that? Do I have to "many_join" all the bookings with all the employees (by week)?`

       

      Thanks a lot!

      Best regards,

       

      DataNibbler