Hi 

I need a list of all accounts, where a contact person exists that has a given email address.

I tired this

var emailAddress = 'user@mydomain.com';

[SELECT Id, Name FROM Account WHERE (SELECT Email FROM Account.Contacts) IN :emailAddress ]

which does not work.

Any ideas?

Thanks

Alex

hi,

is there any way to list out all the objects available in a n SF instance?

i'm using JAVA and an enterprise WSDL.

please help to solve this issue.

regards,

MM Praneeth