Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. SELECT Id, Name, CreatedDate, Createdby.Name, Old_Org_Id__c,
  2. (SELECT Id FROM Orders),
  3. (SELECT Id from Opportunities),
  4. (SELECT Id From Contacts),
  5. (SELECT Id from Tasks),
  6. (SELECT Id from Events)
  7. FROM Account
  8. WHERE BillingStreet = null
  9. AND BillingCity = null
  10. AND BillingState = null
  11. AND BillingPostalCode = null
  12. AND ShippingStreet = null
  13. AND ShippingCity = null
  14. AND ShippingState = null
  15. AND shippingPostalCode = null
  16. AND AP_Account__c = null
  17. AND AR_Account__c = null
  18. AND (NOT Name LIKE '%DADM%')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement