SQOL语句

[nangnangchuai]

• 在线的生成查询语句的网站 https://workbench.developerforce.com/login.php.

• 没有join,object之间有的关系为

• Child-to-parent

  • Account is the parent, and Contact is the child
  • SELECT FirstName, LastName, Account.Name FROM Contact

• Parent-to-children

  • SELECT Name, (Select FirstName, LastName FROM Contacts) FROM Account

    *必须使用Contact的复数形式Contacts

https://trailhead.salesforce.com/content/learn/modules/database_basics_dotnet?trailmix_creator_id=strailhead&trailmix_slug=prepare-for-your-salesforce-platform-developer-i-credential

[nangnangchuai]

sosl:适合横跨好几个对象查询 使用Find soql：适合有某种关系之间的对象的查询