3 Replies Latest reply on Feb 18, 2017 11:18 PM by user28397

    Obtain a list of records from two differents tables

    user28397

      Hi

      I need to have a list of records based on two fields that are in two differents tables.

      Example:

      I want to see all the users that have "this value" in field A in table A and "this value" in field B in table B. This two tables are related.

      I'm building a system for room service. There are people that everyday take their lunch in the room and some other occasionally. I have a field in people table that hold the value: Everyday Room Service: Yes/No

      And then I have another table that record daily room service occasionally.

      What I need is to Have a list that find peoples who have everyday room service and people who occasionally have this service and this filtered for Current Date.

      How can I do this?

      Sql or Find?

       

      Thanks