AnsweredAssumed Answered

Obtain a list of records from two differents tables

Question asked by user28397 on Feb 18, 2017
Latest reply on Feb 18, 2017 by 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

Outcomes