You need to sign in to do that
Don't have an account?
Again Again
Report to show all accounts with no contacts
Hi,
I need to report on all accounts of a certain account type, with no contacts of a certain markup. If I were constructing a SQL query, I'd say something like
select account.accountname
where
Recordtype = 'xxx'
AND ID NOT IN (select AccountID FROM Contact WHERE Contact.Status = 'yyy')
How can this be done in SalesForce / with a related tool?
Thanks!
Tinkylou
Tinkylou
http://www.salesforce.com/appexchange/detail_overview.jsp?id=a0330000000nsOlAAI
Bill
Select * from taccount
where not exists (select 1 from tcontact where tcontact.accountid = taccount.id)
Relational Junction is a complete solution for all your reporting and integration needs which provides 2-way replication from a mirror-image warehouse. It is also platform neutral. We support Oracle, SQL Server, DB2, MySQL, and Sybase, and run on Windows and Unix platforms.
See http://www.sesamesoftware.com
I've been using DBAmp and it's really nice. Thumbs up!
I get an error when I try to get the value of a multi-select picklist. Is there a special way to access this data?