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



      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


      => 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,