thebrettbarlow/SOQL_InnerJoin.sql

Created May 2, 2019 14:50

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/thebrettbarlow/9f61b3c6aabe8c725cbe2e29e7f2a562.js"></script>
Save thebrettbarlow/9f61b3c6aabe8c725cbe2e29e7f2a562 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

SOQL_InnerJoin.sql

	SELECT Id, Name, (SELECT Id, Name, Amount, CloseDate FROM Opportunities)
	FROM Account
	WHERE Id IN (SELECT AccountId FROM Opportunity)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment