I'm going crazy trying to find information on this, which is leading me to believe it's obvious, or I'm trying to use the ZOHO CRM incorrectly.

When filtering contacts, I want to filter them based on a field on their related Account.

Simple Example:

When setting up a mailing list for a campaign, I want all contacts, who's Account belongs to a specific Market Segment, as Market Segment is a field we have on the Accounts module.

Pseudo code Example:

SELECT Contacts WHERE Contacts.Account.MarketSegment = "Medical"

This to me seems like a fundamental property of a relational database.

Some answers i find often refer to using ZOHO creator, but I've not had the time to look deeply into using that, but it seems like overkill for a simple task like this.