I am trying to create a report that has two tables (forms as they're called in Zoho), one table is Stores, the other is Accounts. The Accounts form has a field has a foreign key from the Stores table. How do I create a report that shows me how many Stores do not have a foreign key associated with data in the Accounts table?
The MS-SQL equivalent of the results I would like to see in the report would be:
SELECT s.Store_Name
FROM Stores s
WHERE s.Store_Name NOT IN (
SELECT DISTINCT a.Store_Name
FROM Accounts a)
I'm a bit confused on how to do this with the Zoho Creator.