So, as you Here is my SOQL problem.
from Contact c WHERE c.regcode__c ='XXXXXXXXX'
from Points__c p where p.Account__c ='YYYYYYYYYYYY' and (p.Points__c > 0)
Order by p.Date__c DESC
The relationship between the two queries is that
c.regcode__c will have the same value as
I want to combine Query1 and Query2, so
c.regcode__c = p.Code__c
I'm stuck, I can't seem to get the syntax right for SOQL. Is it even possible to do joins in the API?