You need to sign in to do that
Don't have an account?
Tillu
Please correct this SOQL querry
I have contact as Master and policy as detailed . i want to retrive records from contact. but this gives error.
the error is the subsequent querry contact.id is not recognised. how to write querry for this?
List<Contact> Con = [Select Id, Name from Contact where Id In (Select contact.Id from Policy__c)];
Assuming contact is a lookup field on Policy__c
List<Contact> Con = [Select Id, Name from Contact where Id In (Select contact__c from Policy__c)];
OR
List<Contact> Con = [Select Id, Name from Contact where Id In (Select contact__r.Id from Policy__c)];