You need to sign in to do that
Don't have an account?

malformed query in sforce explorer
hello ,
i am using sforce explorer . i have to do union of the results of two tables i.e. account and lead .
I have fired query i.e. select name from account union select company from lead
I want to union both results in one query , but it is giving me the error "malformed query "
Can anyone tell me whatsthe problem with this ??
and also "order by " is also not working in sforce explorer ..
Plz reply
Thanks,
Guddu
Ref the API Version 7 Manual
Looks like you're trying to use standard SQL not the restricted SOQL set of commands.
Gareth.