I have a relationship like below and i get an error like - the inner select field Customer_r cannot have more than one relationship.
I want to find customers where products are having customer id and belongs to the books category.
Customers_c
- id
- name
- Country
Products
- id,
- name
- category
- Customer_r --> id, name
I tried with the below query but not worked.
SELECT id, name from Customers_c WHERE id IN (SELECT Customer_r.id FROM Products WHERE Customer_r .id != NULL AND category = 'BOOKS')