I am currently learning Salesforce and Apex etc and I am stuck trying to write a trigger which contains a query. Here are my two custom objects:
Student__c (Object)
Nickname__c
Email__c
Application__c:Master Detail Relationship
Application__c related to App__c
App__c (Object)
Name
So, now I want to write a query that fetches the pairs of (Email__c and the correct App__c.Name which is related to the student). So far I have
Select Email__c, Name FROM Student__c, App__c WHERE Application__r.Name = App__c.Name
This is not working, but I cannot quite get my head round querying a Master Detail Relationship. I am sure it's super simple and there is just one little thing I am missing.