Forum Discussion
Syndicate_Admin
Administrator
AdministratorCount how many IDs meet two requirements
Nice day I require your help as I want to count in a table that brings ID and for each ID many answers from these cules ID meet two specific answers This is the table that contains the IDs and resp...
Please provide more detailed description.
Actually that I can't understand the requirement that you post completely.
If possible, please provide your expected result with backend logic and special examples.
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Each combination found in the first table would be counted as 1, and each combination that is required is described in table 2.
For example, if the id "203522243" in all your answers is c4 walmart and c1.5 automercado it would be considered 1
The result is presented in a table like this, being the advance counts combinations found