you can do it by joining that tables three times for each of categories. Or you can write Custom SQL
1 of 1 people found this helpful
I assume you mean "left join", right? Left join plus a filter that checks if at least one category is not null would work.
Custom SQL is a better option though.
PRo tip: you can use Custom SQL only for portion of your relation
How can I use Custom SQL for a portion of my relation? That would be a good solution.
The issue was resolved. Thanks for you support!