function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
maz00maz00 

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.

SuperfellSuperfell
No its doesn't support joins, the right hand clause in a where statement must be a constant value.