Is it possible to compare the Child and Parent field values in a Single SOQL Relationship Query ?
say get me all contacts for an account which doesn't have same name as its parent account.
SELECT Contact.Id, Contact.Name, Account.Id, Account.Name FROM Contact WHERE Account.Id = 'xxxxxxxxxxx' AND Contact.Name <> Account.Name
or get me all opportunities for an account which has same LeadSource as Account
SELECT Id, LeadSource, Account.LeadSource FROM Opportunity WHERE AccountId in : accIdSet AND LeadSource <> Account.LeadSource