'get output by mixing 2 queries
I have one query that output me a list of companies permits with their start dates. I have another list that output me a lot of companies, with let's say, all the activities '01' and their date. I would like to mash these 2 to get the results of every company that had activities '01' only before its permit company start date and not after.
So I should see in my output query for example: a company ABC that have a permit that start with 2021-01-01, and we find that it had an activity '01' before that date and none after.
Is it possible?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|