I need to have a list of records based on two fields that are in two differents tables.
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?