You need to sign in to do that
Don't have an account?
maz00
Nested SQL Select statement
Hi,
Does the API support nested select?
Such as,
qr = binding.query("SELECT Opportunity.Id, Opportunity.AccountId, Opportunity.Name, Opportunity.Description, Opportunity.OwnerId, Opportunity.StageName from Opportunity, Account WHERE Opportunity.AccountId=Account.Id");
Thank you
Maz.
Superfell
No its doesn't support joins, the right hand clause in a where statement must be a constant value.