+ Start a Discussion

Query help for: Account, Asset, Contact

I am running this parent-child query:


SELECT Id, Name,

   (SELECT Id, Name, Description FROM Assets),

   (SELECT Id, Name, Email FROM Contacts)

FROM Account 


How to I exclude resulting records with let say Email=null AND/OR Description=null ?





Nazeer AhamedNazeer Ahamed

Select a.Name, a.Id, (Select Id, Name, Email From Contacts where email = NULL), (Select Id, Name, Description From Assets where Description != NULL) From Account a


But you cannot check Description != NULL as Description is Long Text Area (32000).


Hope this helps.