CQuerying across tables
I am trying to build a dynamic query that can filter records across multiple tables
For example, I have a companies table with name, headcount, and userId
Then I have a crmCompanies table with companyId (relation), crmId, and tier
I want to build a query for companies where userId = X and tier = Y without having to denormalize or fetch all the records in one of the tables
What are my options?
For example, I have a companies table with name, headcount, and userId
Then I have a crmCompanies table with companyId (relation), crmId, and tier
I want to build a query for companies where userId = X and tier = Y without having to denormalize or fetch all the records in one of the tables
What are my options?
