O'Reilly logo

Development with the Force.com Platform: Building Business Applications in the Cloud, Third Edition by Jason Ouellette

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Additional SOQL Features

Although SOQL doesn’t allow arbitrary joins, it provides some control over how related objects are navigated. This section discusses inner and outer joins, as well as semi-joins and anti-joins:

Image Inner join and outer join—SOQL statements that include related objects normally do so by outer join, but can perform an inner join instead using a WHERE clause.

Image Semi-join and anti-join—Semi-join and anti-join are types of relationship queries that use the results of a subquery to filter the records returned from the parent object. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required