Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Id, Name, CreatedDate, Createdby.Name, Old_Org_Id__c,
- (SELECT Id FROM Orders),
- (SELECT Id from Opportunities),
- (SELECT Id From Contacts),
- (SELECT Id from Tasks),
- (SELECT Id from Events)
- FROM Account
- WHERE BillingStreet = null
- AND BillingCity = null
- AND BillingState = null
- AND BillingPostalCode = null
- AND ShippingStreet = null
- AND ShippingCity = null
- AND ShippingState = null
- AND shippingPostalCode = null
- AND AP_Account__c = null
- AND AR_Account__c = null
- AND (NOT Name LIKE '%DADM%')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement