I need to fetch a contact name based on whether a field in account is true and picklist field in contact is 'update' for a case.
I am writing a query that will fetch the data from account, contact and case. Below is the query I've written so far:
SELECT Id, AccountId, Account.Name, owner.name, CaseNumber FROM Case
where Account.checkbox = true and contact.status = 'update'