I know this might sound simple. But I want to make a query that would show ID 1 once based on the criteria of having both Home and Office. I will apply the concept on a bigger database.
ID is from table 1
Date and Location from table 2
Thank you
ID is from table 1
Date and Location from table 2
Thank you